[thelist] MySQL error (version 3.23.47)
HP Thniah
heanpeng at gmail.com
Sat Feb 28 23:01:32 CST 2009
Hi there - please can anybody suggest that I need to do to fix the error
below
Database *users1* running on *localhost**Error*
SQL-query :
CREATE TABLE answer_types (
aid int(11) NOT NULL default '0',
name varchar(50) NOT NULL default '',
type varchar(5) NOT NULL default 'T',
label varchar(255) NOT NULL default '',
sid int(10) unsigned NOT NULL default '0',
PRIMARY KEY (aid)
) CHARACTER SET latin1
TYPE=MyISAM
MySQL said:
You have an error in your SQL syntax near 'CHARACTER SET latin1
TYPE=MyISAM' at line 8
More information about the thelist
mailing list