[PurpleCow]

Hello,

I am getting this error when i run the alter table query.

When i run this query

ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;

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 running on the latest version of mysql, that is almost.

Kindly help me with the right syntax.

Thank you