USE `sql_db`;
DROP PROCEDURE IF EXISTS `TigActiveAccounts`;
CREATE DEFINER=`root`@`localhost` PROCEDURE `TigActiveAccounts`()
begin
select user_jid, last_login, last_logout, online_status, failed_logins, account_status from tig_users where account_status > 0;
end;
报的错是:
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 '' at line 3
CREATE DEFINER=`root`@`localhost` PROCEDURE `TigActiveAccounts`()
begin
select user_jid, last_login, last_logout, online_status, failed_logins, account_status from tig_users where account_status > 0;
end;
$
CREATE DEFINER=`root`@`localhost` PROCEDURE `TigActiveAccounts`()
begin
select user_jid, last_login, last_logout, online_status, failed_logins, account_status from tig_users where account_status > 0;
end;//
delimiter ;
我是通过shell执行x.sh文件,然后执行一个x.sql脚本,脚本里写了这个存储过程,但是报这个错,1楼,2楼的写法,好像都不行啊,delimiter好像不是关键字啊
为嘛我的mysql_real_query(conn,"delimiter $$", ...)返回的一直就是-1呢?