Menu

#4 sql syntax errors

open
nobody
5
2010-06-01
2010-06-01
mbbcat
No

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

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.