/*显示表结构*/
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();