stored PROCEDURE problem
Posted: Sat Sep 15, 2007 10:11 am
Here is my sql statement:
I am using:
# Server version: 5.0.41-community-nt
# Protocol version: 10
# Server: localhost via TCP/IP
# User: root@localhost
# phpmyadmin
when i try to run above mentioned statement I get following 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 'select loginid from user where loginid=userid' at line 6
any help?
thanks
Code: Select all
DROP PROCEDURE IF EXISTS `check_user`;
CREATE PROCEDURE `check_user`(IN userid VARCHAR(25))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
select loginid from user where loginid=userid;
END;I am using:
# Server version: 5.0.41-community-nt
# Protocol version: 10
# Server: localhost via TCP/IP
# User: root@localhost
# phpmyadmin
when i try to run above mentioned statement I get following 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 'select loginid from user where loginid=userid' at line 6
any help?
thanks