记录一下mysql客户端的命令语句

建表

drop table if exists newsPush;
create table newsPush(
id    int(11) auto_increment primary key,
createTime    bigint,
altfield1    varchar(50),
altfield2    varchar(50),
altfield3    varchar(50)
);

truncate删除表数据

TRUNCATE table customer;

查看安装目录/日志目录，编码方式

show variables like "%slow%";
show variables like "%char%";

查询是否开启log_bin

show variables like '%log_bin%';

设置-查询最大连接数

set global max_connections=1000;

show variables like 'max_connections';

从一张表导入另一张表

INSERT into innData select * from innData_copy;

复制-导入表数据

INSERT into userFollow(createTime,openid) select createTime,openid from weiXinUser;

查看版本

select VERSION();