Saturday, April 30, 2011

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]

No comments: