Posted by Rich on 02/22/06 20:48

In article <mn.aaa47d62e45d37e8.49879@email.it>, maux says...
>
>how can i fix this?
>
>Errore
>
>query SQL :
>
>CREATE TABLE `tags` (
> `tag_link_id` int(11) NOT NULL default '0',
> `tag_lang` varchar(4) NOT NULL default 'en',
> `tag_date` timestamp NOT NULL,
> `tag_words` varchar(64) NOT NULL default '',
> UNIQUE KEY `tag_link_id` (`tag_link_id`,`tag_lang`,`tag_words`),
> KEY `tag_lang` (`tag_lang`,`tag_date`)
>) ENGINE=MyISAM
>
>Messaggio di MySQL:
>
>
>You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 8
>
>
>
>thanks for help
>
>

Not sure if you might need to use "TYPE=MyISAM" instead of "ENGINE=MyISAM".

Rich
--
Newsguy BonusBytes! - Free monthly rewards
http://newsguy.com/bonusbytes.htm

• Next in forum: Re: How can i display a list of mysql databases in php?
• Prev in forum: Re: want to create table from old table
• Thread view: Re: query error

[Reply to this message]