报错[Err] 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 'mysql> delimiter 这是源代码:mysql>delimiter
这是源代码:
mysql> delimiter 这是源代码:mysql>delimiter
mysql> create procedure teachernfo1(in teacherid int(10),in type int(10),out info)
-> begin
-> if type=1 then select name into info from teacherinfo where num=teacherid;
-> else if type=2 then select (datediff(now(),birthday)/365)from teacherinfo where num=teacherid;
-> else set info=‘Error’;
-> end mysql>delimiter;为什么报错[Err]1064−YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear′mysql>delimiter
mysql> delimiter;
为什么报错[Err] 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 'mysql> delimiter mysql>delimiter;为什么报错[Err]1064−YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear′mysql>delimiter
那位大佬看看吧,谢谢了!!