MySQL uses Informatin_schema tables to create the shell commands

Select CONCAT ("Mysqldump-uroot-p", Table_schema, "", TABLE_NAME, ">>", Table_schema, ". Bak.sql")

From INFORMATION_SCHEMA WHERE table_name like ' country% ';

You can also save the generated shell command in a file (but it must be a local folder, or the host folder where the client resides, or the mapped server folder, and the file does not exist)

Select CONCAT ("Mysqldump-uroot-p", Table_schema, "", TABLE_NAME, ">>", Table_schema, ". Bak.sql")

From INFORMATION_SCHEMA WHERE table_name like ' country% '

Into OUTFILE ' c:/sample.sh ';

The Concat () method is a string join method, and if it contains null, the result is null, specifically see

Http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_concat

MySQL uses Informatin_schema tables to create the shell commands