Question about 'mysql error 1064'
mysql error 1064


The error that gets thrown if the syntax is wrong. You did not clearly state what you are doing. 

If you are changing a column

ALTER TABLE table_name MODIFY COLUMN column_name datatype


If you are trying to change column definition

ALTER TABLE table_name CHANGE old_column_name new_column_name data_type(size)


If you are adding a new column

ALTER TABLE table_name ADD column_name datatype