delimiter $$ CREATE PROCEDURE VPN_LOGINUSER(in qqNAME VARCHAR(50), in qqPass VARCHAR(20) ) BEGIN SELECT * FROM vpnplayer WHERE vpnNAME=qqNAME AND vpnPASS=qqPass; END$$
DELIMITER $$CREATE PROCEDURE `test`.`prc_test`(INqqNAME VARCHAR(50),INqqPass VARCHAR(20))BEGIN SELECT * FROM vpnplayer WHERE vpnNAME=INqqNAME AND vpnPASS=INqqPass; END$$DELIMITER ;
DELIMITER $$CREATE PROCEDURE `test`.`prc_test`(INqqNAME VARCHAR(50),INqqPass VARCHAR(20)) BEGIN SELECT * FROM vpnplayer WHERE vpnNAME=INqqNAME AND vpnPASS=INqqPass; END$$DELIMITER ;
你的问题是select语句没有打分号结束 而且开始需要定义结束符 delimiter $$ 在end处使用$$
SELECT * FROM vpnplayer WHERE vpnNAME=qqNAME AND vpnPASS=qqPass;
mysql> CREATE PROCEDURE VPN_LOGINUSER
-> (
-> in qqNAME VARCHAR(50),
-> in qqPass VARCHAR(20)
-> )
-> BEGIN
-> SELECT * FROM vpnplayer WHERE vpnNAME=qqNAME AND vpnPASS=qqPass;
-> END;
-> //
Query OK, 0 rows affected (0.00 sec)
DELIMITER $$CREATE PROCEDURE `test`.`prc_test`(INqqNAME VARCHAR(50),INqqPass VARCHAR(20))BEGIN
SELECT * FROM vpnplayer WHERE vpnNAME=INqqNAME AND vpnPASS=INqqPass;
END$$DELIMITER ;
BEGIN
SELECT * FROM vpnplayer WHERE vpnNAME=INqqNAME AND vpnPASS=INqqPass;
END$$DELIMITER ;