mysql problems

[AN-net]

im having problems with using ALTER TABLE ADD

im getting syntax errors:

Originally Posted by mysql

SQL-query :

ALTER TABLE affiliates2 ADD 'clicksin'int( 20 ) DEFAULT '0' NOT NULL

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 ''clicksin'int( 20 ) DEFAULT '0' NOT NULL' at line 1

anyone know how to use this query correctly?

[assassingod]

Try:
[sql]
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL ;
[/sql]