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;
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
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
someone pls help me with the right syntax for that query and the latest version of mysql.
Thank you