xxxxxxxxxx
ALTER TABLE `employees`CHANGE `emp_id` `emp_id` int(11) NULL;
xxxxxxxxxx
ALTER TABLE mytable ADD new_column BLOB NOT NULL AFTER father_name;
ALTER TABLE mytable
CHANGE COLUMN
dad_name new_col_name VARCHAR(30) NOT NULL DEFAULT 'I forgor';
xxxxxxxxxx
mysql> alter database university character set utf8 collate utf8_general_ci;