Error in sql syntax - #1064

[gomzi]

DELIMITER $$

DROP PROCEDURE IF EXISTS `tableselect` $$
CREATE PROCEDURE `tableselect`()
BEGIN
select * from table_a;
END $$

DELIMITER ;

when i try to create a procedure by using the code specified above, i get this error.

#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 'DELIMITER $$

DROP PROCEDURE IF EXISTS `tableselect` $$
CREATE PROCEDURE `' at line 1

i use mysql 5.0

any help would be appreciated.

thanks,
gomzi.

[ScarletPimpernal]

Hi Gomzi,

Try this

mysql> DELIMITER $$
mysql> DROP PROCEDURE IF EXISTS `tableselect` $$ CREATE PROCEDURE `tableselect`()
Query OK, 0 rows affected, 1 warning (0.00 sec)

-> BEGIN
-> select * from table_a;
-> END;
-> $$
Query OK, 0 rows affected (0.00 sec)


Thanks,
Scarlet

[masdi2t]

DELIMITER $$

DROP PROCEDURE IF EXISTS `tableselect` $$
CREATE PROCEDURE `tableselect`()
BEGIN
select * from table_a;
END $$

DELIMITER ;

when i try to create a procedure by using the code specified above, i get this error.

#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 'DELIMITER $$

DROP PROCEDURE IF EXISTS `tableselect` $$
CREATE PROCEDURE `' at line 1

i use mysql 5.0

any help would be appreciated.

thanks,
gomzi.

try cache your delimiter character with ;;

DELIMITER ;;

DROP PROCEDURE IF EXISTS `tableselect` ;
CREATE PROCEDURE `tableselect`()
....

DEMIMITER ;

[masdi2t]

try cache your delimiter character with ;;

DELIMITER ;;

DROP PROCEDURE IF EXISTS `tableselect` ;
CREATE PROCEDURE `tableselect`()
....

DEMIMITER ;

thus should change