MySQL Forums
Forum List  »  InnoDB

Error while executing the below command
Posted by: venkat t
Date: December 15, 2005 06:08AM

Error while executing the below command

Hi,
I am venkat, whenever i am trying to execute the below command

CREATE TABLE `test` (
`id` int(11) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


i am getting the following error.

[singularity] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 3

plz help me, i am totally blocked with this error message.
Thanks in advance.
Venkat.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error while executing the below command
1896
December 15, 2005 06:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.