[stan68]

im getting a error when trying to add the query

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;

first error is this
Error

SQL-query :

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL

MySQL said:


Unknown column 'clicks' in 'affiliates'
and the other is this


Error

SQL-query :

ALTER TABLE affiliates2 ADD clicksin INT( 20 ) DEFAULT '0' NOT NULL ,
ADD approved tinyint( 4 ) NOT NULL

MySQL said:


Table 'nukesm.affiliates2' doesn't exist