|
|
Posted by Jim Michaels on 02/23/06 12:19
"Rich" <rich@newsguy.com> wrote in message
news:dtibl201nsg@drn.newsguy.com...
> 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".
in 5.0 it can be either ENGINE or TYPE. the engines can be
ARCHIVE,BDB,CSV,EXAMPLE,FEDERATED,HEAP,ISAM,InnoDB,MEMORY,MERGE,MyISAM,NDBCLUSTER.
Hey, case shouldn't matter, but try it anyway it's safer.
Is MyISAM enabled as a storage engine type in MySQL? Or is it InnoDB only?
>
> Rich
> --
> Newsguy BonusBytes! - Free monthly rewards
> http://newsguy.com/bonusbytes.htm
>
Navigation:
[Reply to this message]
|