DBMSL -Assignment No 2 DDL Part 2 | Alter table, Rename table, Truncate table, drop column in MySQL
DDL Part-2
MySQL Commands
_________________________________________________________
Alter table-
Add column at first, add column at particular position, add column at last,
Alter table Modify column data type and size.
Alter table drop column( remove column from table)
Alter table Change column name
Alter table rename table name in MySQL.
_________________________________________________________
Truncate table
Difference between Truncate table and drop table in MySQL
__________________________________________________________