BEGIN
SELECT * FROM vpnplayer WHERE vpnNAME=qqNAME AND vpnPASS=qqPass
END;
一直提示:
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 user near in qqPass VARCHAR
我还真看不出这代码有什么问题。
...全文
1138打赏收藏
mysql 1064
code: CREATE PROCEDURE VPN_LOGINUSER ( in qqNAME VARCHAR(50), in qqPass VARCHAR(20) ) BEGIN SELECT * FROM vpnplayer WHERE vpnNAME=qqNAME AND vpnPASS=qqPass END; 一直提示: ERROR 1064 : You have an error in your SQL syntax; check the manual that correspond
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 ;
delimiter $$
CREATE PROCEDURE VPN_LOGINUSER(in qqNAME VARCHAR(50), in qqPass VARCHAR(20) )
BEGIN
SELECT * FROM vpnplayer WHERE vpnNAME=qqNAME AND vpnPASS=qqPass;
END$$