Posted by maux on 02/23/06 14:58

Nel suo scritto precedente, Jim Michaels ha sostenuto :
> "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
>>

hi thanks to all ,i resolved with TYPE=MyISAM" instead of
"ENGINE=MyISAM
;o)

[Back to original message]