[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