sql常用，0.0

/*显示表结构*/
desc jsp

/*删除表*/
drop table xxx;

/*添加列和删除列*/
alert table jsp add age int(7);
alert table jsp drop column age;

/*重命名*/
rename table jsp to Jsp;

/*重命名表中字段名*/
alter table jsp change cara card int(7) not null;

/*获取自动增长的值*/
select LAST_INSERT_ID();