？ contents; //查看帮助
show [globle|session] status; //查看运行状态
show [globle|session] variables [like condition]; //查看配置项
load data infile path into tablename; // 从文件导入数据
select columnlist from tablename into outfile path; // 导出指定表的列至外部文件
check table tablename; //检查表
optimize table tablename;// 优化表
rename table tablename to new_tablename; //修改表明
create table new_tablename like old_tablename; // 复制表
create table new_tablename select * from old_tablename; // 复制表数据
原文：http://www.cnblogs.com/lpfuture/p/4623646.html