mysql静默登录_MySQL 实用技巧

[04:06:57](root@localhost)[(none)] > select concat('select * into outfile \'/tmp/',table_name,'.csv\' from ',table_schema,'.',table_name,';')

from information_schema.tables where  table_schema='test';

+---------------------------------------------------------------------------------------------------+

| concat('select * into outfile \'/tmp/',table_name,'.csv\' from ',table_schema,'.',table_name,';') |

+---------------------------------------------------------------------------------------------------+

| select * into outfile '/tmp/address.csv' from test.address; |

| select * into outfile '/tmp/address1.csv' from test.address1; |

| select * into outfile '/tmp/clone_t.csv' from test.clone_t; |

| select * into outfile '/tmp/lock_test.csv' from test.lock_test; |

| select * into outfile '/tmp/query_history.csv' from test.query_history; |

| select * into outfile '/tmp/query_review.csv' from test.query_review; |

| select * into outfile '/tmp/ram.csv' from test.ram; |

| select * into outfile '/tmp/t.csv' from test.t; |

| select * into outfile '/tmp/t1.csv' from test.t1; |

| select * into outfile '/tmp/t2.csv' from test.t2; |

| select * into outfile '/tmp/t3.csv' from test.t3; |

| select * into outfile '/tmp/z.csv' from test.z; |

+---------------------------------------------------------------------------------------------------+

当需要对数据库的表进行批量操作时，通过这种方式批量生成语句能大大提高效率

2、去除结果的虚线框并将结果输出到文件中-- 通常我们需要将生成的语句保存到一个文件中，并且运行，这时就需要配合tee命令以及mysql客户端的参数了

mysql --skip-column-names --silent (简写为 mysql -ss)能以静默方式登录MySQL服务器并不显示输出结果的虚线框

tee /tmp/export.sql　　　　 将执行的结果保存到文件中