Alter Table students ADD(age INT, country Varchar(10), nationality Varchar);
Alter Table students Drop Column nationality;
Alter Table students Modify country Varchar(88);
You are viewing a single comment's thread from:
Alter Table students ADD(age INT, country Varchar(10), nationality Varchar);
Alter Table students Drop Column nationality;
Alter Table students Modify country Varchar(88);
Update table_name
Set col_name =' Harper Building'
Where department = ' engineering'