Can't copy table

[jlsohio]

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

 

 

[Ken2k7]

Put a space after 68.

[jlsohio]

I'm not sure how to do that? I'm using the copy table function.

[Maq]

You can manually do it in PhpMyAdmin.