CREATE TABLE cofee_store(
id int primary key,
product_id int,coustomer_id int,
product_time datetime);
Alter table cofee_store
Add column cofee_orgin varchar(20);
describe cofee_store;
Alter table cofee_store
drop column cofee_orgin;
drop table cofee_store;
describe cofee_store;
create table test(Id int auto_increment primary key,name varchar(20),age int );
insert into test (id,name,age)
values(1,'alphin',22),(2,'aliwin',22),(3,'Ashwin',22);
select * from test;
describe test;
-- truncate table test;
-- select * from test;
alter table test
change column name first_name varchar(25);
describe test;