Mysql expert required

[warleb]

Does anyone know how to solve this issue?

 

Error

SQL query:

 

CREATE TABLE `sms_defaults` (

 

`sms_default_message_id` int( 32 ) NOT NULL AUTO_INCREMENT ,

`sms_default_message_name` varchar( 50 ) NOT NULL default '',

`sms_language_id` int( 5 ) NOT NULL default '0',

`sms_default_message_text` varchar( 160 ) default NULL ,

PRIMARY KEY ( `sms_default_message_id` )

) ENGINE = MYISAM DEFAULT CHARSET = latin1;

 

 

 

MySQL said:

 

#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 'DEFAULT CHARSET=latin1' at line 7

[user99999999]

You can just remove this part it will use the defaults.

 

ENGINE = MYISAM DEFAULT CHARSET = latin1

 

The statement changed in mysql 3.x type=myisam and 4.x engine=myisam

[warleb]

You can just remove this part it will use the defaults.

 

ENGINE = MYISAM DEFAULT CHARSET = latin1

 

The statement changed in mysql 3.x type=myisam and 4.x engine=myisam

 

 

That's great. It worked a treat.

 

Cheers

Steve