mysql> show database;
ERROR 1064 (42000): 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 'datab
ase' at line 1是什麼問題,請各位幫忙!
ERROR 1064 (42000): 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 'datab
ase' at line 1是什麼問題,請各位幫忙!
你少了一个S。
建存儲過程。
CREATE procedure totalsalary(out total float)
BEGIN
select total(salary) into total from employ;
END
delimiter;輸入EMPLOY ;時MYSQL認為結束了。
如何處理?
建存儲過程時提示MYSQL.proc不存在。
這個表如何建?有何要求?