intento generar esta consulta:
CREATE TABLE `flash_news` (
* `id` smallint( 5 ) NOT NULL AUTO_INCREMENT ,
* `author` varchar( 60 ) NOT NULL default '',
* `timestamp` int( 10 ) NOT NULL default '0',
* `title` varchar( 200 ) NOT NULL default '',
* `body` text NOT NULL ,
* PRIMARY KEY*( `id` )
) TYPE = MYISAM
y me da este error:
#1064 - You have an error in your SQL syntax near 'id`smallint(5) NOT NULL auto_increment ,
* `author`varchar(60) NOT NULL defaul' at line 2
si m podeis ayudar