Mysql syntax help !

Hello,

I want to run this query in my mysql db :

ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;
But when i run the query, i get the following error :

SQL Error 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 '; ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0
I am alsomost running on the latest version of mysql...!

someone pls help me with the right syntax for that query and the latest version of mysql.

Thank you

 

 

 

 

Top