Mysql_select output to a file in the specified format

Setup1:
Generate the table name file that you want to query:
Select table_name from TABLES where table_schema= ' test ' and table_name as ' cust_biz% ' into outfile '/tmp/tab.txt '
SETUP2:
Write the shell, query related data from the library, and output to a file in a custom format:
[email protected] ~]# cat test.sh
#!/bin/sh
rm-rf/tmp/cst/*
Dbuser=root
dbpwd=111222
#DBIP =127.0.0.1
While Read New_tab
Do
Mysql-n-u$dbuser-p$dbpwd-p3306-e "Use Custmis; SELECT * into outfile '/tmp/cst/$new _tab.txt ' fields TERMINATED by ', ' enclosed by ' ' LINES TERMINATED by ' \ r \ n ' from $n Ew_tab; "
Done </tmp/tab.txt

Mysql_select output to a file in the specified format