Mysql problem

Does anyone see a problem with this query?
It works on mysql 4.0.25-standard
But not mysql 4.1.18-standard

This is the query:

DROP TABLE IF EXISTS ms_train;
CREATE TABLE ms_train (
  id int(10) NOT NULL auto_increment,
  on int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

Code (markup):

 

this is because you try to use the reserved word in mysql.
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

use something else other than 'on'. it must work.

 

Thanks for the help, Vishwaa, I appreciate it!