mysql - Can anyone find the error error in sql syntax

Question

Can someone tell me what wrong with this code

Table structure for table epay_area_list

CREATE TABLE epay_area_list(
   id tinyint( 3 ) unsigned NOT NULL AUTO_INCREMENT ,
   titlechar( 30 ) NOT NULL default '',
   parent tinyint( 4 ) NOT NULL default '0',
   akey bigint( 20 ) NOT NULL default '0',
   PRIMARY KEY ( id )
) TYPE = 'MyISAM';

MySQL said:

Documentation #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 'TYPE='MyISAM'' at line 23

I would appreciate any help

Answer 1

You're missing a space between title and its datatype char( 30 ):

CREATE TABLE IF NOT EXISTS epay_area_list (
   id tinyint( 3 ) unsigned NOT NULL AUTO_INCREMENT ,
   title char( 30 ) NOT NULL default '', -- ADDED SPACE HERE
   parent tinyint( 4 ) NOT NULL default '0',
   akey bigint( 20 ) NOT NULL default '0',
   PRIMARY KEY ( id )
) TYPE = 'MyISAM';