Sql error code

Client Joined: Feb 18, 2004 Posts: 22 Location: Israel

Pls, what is this error is saying to me, can anyone put into simple words??

Error
SQL query:

--
-- Table structure for table `nuke_authors`
--
CREATE TABLE `nuke_authors` (

`aid` varchar( 25 ) NOT NULL default '',
`name` varchar( 50 ) default NULL ,
`url` varchar( 255 ) NOT NULL default '',
`email` varchar( 255 ) NOT NULL default '',
`pwd` varchar( 40 ) default NULL ,
`counter` int( 11 ) NOT NULL default '0',
`radminsuper` tinyint( 1 ) NOT NULL default '1',
`admlanguage` varchar( 30 ) NOT NULL default '',
PRIMARY KEY ( `aid` ) ,
KEY `aid` ( `aid` )
) ENGINE = MYISAM DEFAULT 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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 12

TIA
Lart

Posted: Sun Apr 16, 2006 8:00 pm

Try

Code:

-- 


-- Table structure for table `nuke_authors` 


-- 


CREATE TABLE `nuke_authors` ( 





`aid` varchar( 25 ) NOT NULL default '', 


`name` varchar( 50 ) default NULL , 


`url` varchar( 255 ) NOT NULL default '', 


`email` varchar( 255 ) NOT NULL default '', 


`pwd` varchar( 40 ) default NULL , 


`counter` int( 11 ) NOT NULL default '0', 


`radminsuper` tinyint( 1 ) NOT NULL default '1', 


`admlanguage` varchar( 30 ) NOT NULL default '', 


PRIMARY KEY ( `aid` ) , 


KEY `aid` ( `aid` ) 


) TYPE = MYISAM;