MySQL问题解决 [Err] 1064 - You have an error in your SQL syntax;

927 阅读1分钟

问题:

[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 ‘select s.StudentNo,s.StudentName from Student_kb03 s where s.StudentNo in (sel’ at line 14

原因:

sql语句后面没有写“;” ,细节问题,以后还要多留心。