Home > Archive > PHP SQL > February 2006 > query error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
|
| 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
| |
| Jim Michaels 2006-02-23, 7:56 am |
|
"Rich" <rich@newsguy.com> wrote in message
news:dtibl201nsg@drn.newsguy.com...
> In article <mn.aaa47d62e45d37e8.49879@email.it>, maux says...
>
> 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,I
SAM,InnoDB,MEMORY,MERGE,MyISAM,NDBCLUSTE
R.
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
>
| |
|
| Nel suo scritto precedente, Jim Michaels ha sostenuto :[color=darkred]
> "Rich" <rich@newsguy.com> wrote in message
> news:dtibl201nsg@drn.newsguy.com...
>
>
> in 5.0 it can be either ENGINE or TYPE. the engines can be
> ARCHIVE,BDB,CSV,EXAMPLE,FEDERATED,HEAP,I
SAM,InnoDB,MEMORY,MERGE,MyISAM,NDBCLUSTE
R.
> 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?
>
>
hi thanks to all ,i resolved with TYPE=MyISAM" instead of
"ENGINE=MyISAM
;o)
| |
| Jim Michaels 2006-02-23, 9:56 pm |
|
"maux" <maux@email.it> wrote in message
news:mn.bb467d62eb77b73a.49879@email.it...
> Nel suo scritto precedente, Jim Michaels ha sostenuto :
>
> 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.
>
>
|
|
|
|
|