mysql 基本语句

create  table test (id int auto_increment,name varchar(255),price decimal); 

alter table test add decsri text,add date datetime after price;

alter table test drop descri ,drop price;