mysql 常用语句

? 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; //  复制表数据

原文地址:https://www.cnblogs.com/lpfuture/p/4623646.html