MySQL - Quick Command Reference

Alter Table

Change data type of a column

mysql> alter table 
-> change   varchar(100); <-- new data type to be changed to

Update Table

Change value of a Column based on a condition

UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]