MySQL table creation error - with CHARSET
Posted by: Nuwan Gurusinghe
Date: May 16, 2005 05:20AM

I have this script to create a table in MySQL.

The version I use is 3.23.56



CREATE TABLE ApplicantEvaluate (
ID int(10) unsigned NOT NULL default '0',
EmployeeID int(10) unsigned NOT NULL default '0',
Evaluation smallint(4) unsigned default NULL,
Reason varchar(100) default NULL,
Opportunity smallint(4) unsigned default NULL,
EvaluDate date default NULL,
Memo varchar(200) default NULL,
HopeMemo varchar(200) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM DEFAULT CHARSET=latin1;

----------------------------------------------------------------------------------
This gives the following error when executing

ERROR 1064: You have an error in your SQL syntax near 'DEFAULT CHARSET=latin1' at line 11
----------------------------------------------------------------------------------

Can somebody please let me know what is the problem with this script. I appreciate a quick reply as thanks in advance.

Cheers

Nuwan

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL table creation error - with CHARSET
2871
May 16, 2005 05:20AM


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.