Useful SQL queries

Drop two columns from a table

ALTER TABLE MyTable DROP COLUMN Column1, DROP COLUMN Column2;

Add twocolumns into a table

ALTER TABLE MyTable ADD COLUMN Column1 INT(11) DEFAULT '0', ADD COLUMN Column2 INT(11) DEFAULT '0';