mysql批量数据多次查询数据库_mysql数据库批量操作

批量KILL会话：

1.首先，根据条件将查询到要kill的进程写入文件；如：

desc information_schema.processlist;

SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root'; 或者根据status

SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root' INTO OUTFILE '/tmp/a.txt';

2.然后倒入这个文件，即可kill掉mysql进程：

source /tmp/a.txt;

http://blog.163.com/yang_jianli/blog/static/161990006201231124951692/

批量导入CSV等文件数据

1、首先对应文件列建好表

2、执行下面命令

load data local infile 'e:\\test.csv'

into table test_table

fields terminated by ',' optionally enclosed by '"' escaped by '"'

lines terminated by '\r\n';