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 ? Link to comment https://forums.phpfreaks.com/topic/120699-solved-strange-mysql-import-error/ 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 Link to comment https://forums.phpfreaks.com/topic/120699-solved-strange-mysql-import-error/#findComment-621940 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) Link to comment https://forums.phpfreaks.com/topic/120699-solved-strange-mysql-import-error/#findComment-621941 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. Link to comment https://forums.phpfreaks.com/topic/120699-solved-strange-mysql-import-error/#findComment-622056 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.