How to Add a Column in MySQL

In MySQL (as in many other SQL databases), in order to add a new column you need to use an alter table as below:

alter table employee add column last_bonus_date date;

The value of the new column will be NULL for all the existing rows in the table.

IN THIS PAGE