jlsohio Posted May 26, 2009 Share Posted May 26, 2009 Versions: MySQL-5.0.45 phpMyAdmin - 2.8.0.1 I was trying to copy a table in MySQL database, I got this error: CREATE TABLE `jugmas`.`2009_top_3yr_olds` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `horse` varchar( 20 ) NOT NULL , `starts` int( 2 ) NOT NULL default '0', `first` int( 2 ) NOT NULL default '0', `second` int( 2 ) NOT NULL default '0', `third` int( 2 ) NOT NULL default '0', `record` varchar( 4 ) NOT NULL default '', `earnings` int( 7 ) NOT NULL default '0', `jug_eligible` char( 3 ) NOT NULL default '0', UNIQUE KEY `horse` ( `horse` ) , KEY `id` ( `id` ) ) ENGINE = MYISAM AUTO_INCREMENT = 68DEFAULT CHARSET = latin1 MySQL said: #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 '68DEFAULT CHARSET = latin1' at line 11 Quote Link to comment https://forums.phpfreaks.com/topic/159705-cant-copy-table/ Share on other sites More sharing options...
Ken2k7 Posted May 26, 2009 Share Posted May 26, 2009 Put a space after 68. Quote Link to comment https://forums.phpfreaks.com/topic/159705-cant-copy-table/#findComment-842341 Share on other sites More sharing options...
jlsohio Posted May 26, 2009 Author Share Posted May 26, 2009 I'm not sure how to do that? I'm using the copy table function. Quote Link to comment https://forums.phpfreaks.com/topic/159705-cant-copy-table/#findComment-842384 Share on other sites More sharing options...
Maq Posted May 26, 2009 Share Posted May 26, 2009 You can manually do it in PhpMyAdmin. Quote Link to comment https://forums.phpfreaks.com/topic/159705-cant-copy-table/#findComment-842389 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.