maliary Posted August 21, 2008 Share Posted August 21, 2008 Hi I am using mysql 4.0.26-nt-log, I am importing a database and I keep getting this error, Error 1064 at line 703313: 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 'case int(11) default null,result_date date NOT NULL default What could be causing it ? How can I resolve it ? Quote Link to comment Share on other sites More sharing options...
maliary Posted August 21, 2008 Author Share Posted August 21, 2008 The mysql versions are the same for the source and the destination Quote Link to comment Share on other sites More sharing options...
paul2463 Posted August 21, 2008 Share Posted August 21, 2008 case is a mysql reserved word put back ticks around it `case` int(11) Quote Link to comment Share on other sites More sharing options...
maliary Posted August 21, 2008 Author Share Posted August 21, 2008 Thank you very much. That has sorted the issue. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.