query error
am 21.02.2006 11:16:14 von maux
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
Re: query error
am 22.02.2006 19:48:02 von unknown
Post removed (X-No-Archive: yes)
Re: query error
am 23.02.2006 11:19:30 von Jim Michaels
"Rich" wrote in message
news:dtibl201nsg@drn.newsguy.com...
> In article , 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,ME RGE,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
>
Re: query error
am 23.02.2006 13:58:47 von maux
Nel suo scritto precedente, Jim Michaels ha sostenuto :
> "Rich" wrote in message
> news:dtibl201nsg@drn.newsguy.com...
>> In article , 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,ME RGE,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)
Re: query error
am 24.02.2006 02:50:25 von Jim Michaels
"maux" wrote in message
news:mn.bb467d62eb77b73a.49879@email.it...
> Nel suo scritto precedente, Jim Michaels ha sostenuto :
>> "Rich" wrote in message
>> news:dtibl201nsg@drn.newsguy.com...
>>> In article , 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,ME RGE,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.
>
>