使用mysql 命令创建 SQL 语句
mysql> SELECT CONCAT("mysqldump -uroot -p ",
-> TABLE_SCHEMA," ", TABLE_NAME, " >> ",
-> TABLE_SCHEMA,".bak.sql")TA
-> FROM TABLES WHERE TABLE_NAME LIKE 'employees';
将生成以下 shell 命令:
shell> mysqldump -uroot -p classicmodels employees