Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 1677
STR: //
SQL: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;# MySQL returned an empty result set (i.e. zero rows).
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;# MySQL returned an empty result set (i.e. zero rows).
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';# MySQL returned an empty result set (i.e. zero rows).
CREATE SCHEMA IF NOT EXISTS `w3pw` ;# MySQL returned an empty result set (i.e. zero rows).
USE `w3pw`;# MySQL returned an empty result set (i.e. zero rows).
-- -----------------------------------------------------
-- Table `w3pw`.`main`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `w3pw`.`main` (
`version` VARCHAR(25) CHARACTER SET 'latin1' COLLATE 'latin1_general_ci' NOT NULL ,
`pw` VARCHAR(255) CHARACTER SET 'latin1' COLLATE 'latin1_general_ci' NOT NULL DEFAULT '' )
ENGINE = MyISAM
DEFAULT CHARACTER SET = latin1;# MySQL returned an empty result set (i.e. zero rows).
-- Insert data into 'main'
-- USER DO: Change 'secret' to whatever pw you want to use as your main pw.
INSERT INTO `main` VALUES ('1.5.0-beta3', sha1('secret'));# 1 row(s) affected.
-- -----------------------------------------------------
-- Table `w3pw`.`wallet`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `w3pw`.`wallet` (
`ID` INT(11) NOT NULL AUTO_INCREMENT ,
`itemname` TINYBLOB NOT NULL ,
`host` TINYBLOB NOT NULL ,
`login` TINYBLOB NOT NULL ,
`pw` TINYBLOB NOT NULL ,
`comment` MEDIUMBLOB NOT NULL ,
PRIMARY KEY (`ID`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = latin1;# MySQL returned an empty result set (i.e. zero rows).
DELIMITER //
//
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`()
BEGIN
select *
from wallet;
END//
DELIMITER //
//
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`()
BEGIN
select *
from wallet;
END//
DELIMITER //
//
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`()
BEGIN
select *
from wallet;
END//
DELIMITER //
//
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`()
BEGIN
select *
from wallet;
END//
DELIMITER //
//
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`()
BEGIN
select *
from wallet;
END//
DELIMITER //
//
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`()
BEGIN
select *
from wallet;
END//
SQL query:
DELIMITER // // CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`() BEGIN select * from wallet; END//
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all_from_wallet`()
BEGIN
' at line 1