use mysql;
show tables;
select * from db;
desc db;
create database test1;
show create table demo ;
desc demo;
alter table demo modify NAME varchar(64);
alter table demo add column age int(3);
desc demo;
alter table demo modify AGE INT(3);
alter table demo drop column age;
alter table demo change age age1 int(4);
show tables;
select * from db;
desc db;
create database test1;
show create table demo ;
desc demo;
alter table demo modify NAME varchar(64);
alter table demo add column age int(3);
desc demo;
alter table demo modify AGE INT(3);
alter table demo drop column age;
alter table demo change age age1 int(4);