Page 1 of 1

stored PROCEDURE problem

Posted: Sat Sep 15, 2007 10:11 am
by itsmani1
Here is my sql statement:

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

Posted: Sat Sep 15, 2007 1:57 pm
by Weirdan
update your phpMyAdmin. v 2.11.0 is said to have support for triggers, views and stored routines