How to Add Column to a Table in MySQL
Notes:
How to add a column into an already created table:
- To add a column into an already created table; we take help of alter table command
Basic Syntax:
alter table tablename add columnname datatype [(size) not null default value];
Ex:
alter table tbl_faculty add DOB date;
Interview Questions:
