Posted by Jim Michaels on 02/24/06 03:50

"maux" <maux@email.it> wrote in message
news:mn.bb467d62eb77b73a.49879@email.it...
> 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)

Must be a 4.x version of MySQL or earlier I guess. if it's a local install,
specifying the table type isn't necessary at all, unless it's MySQL and
you're trying to mess with FOREIGN KEYs.

>
>

[Back to original message]