bash怎么调用sql并保存结果

mysql -uroot -pP@ssw0rd123.abc -h127.0.0.1 -P3306 -e \
'select c.TABLE_SCHEMA ,c.TABLE_NAME ,c.COLUMN_NAME ,c.COLUMN_TYPE ,c.COLUMN_KEY from information_schema.COLUMNS c
where c.TABLE_SCHEMA in ("a5_dtx","a5_fund","a5_manage","a5_secinit","a5_sectrade","a5_sysinfo")
and c.TABLE_NAME not like "%copy%";' >> ${sql_file} 2>&1

posted @ 2022-05-31 09:21  孙犯困  阅读(124)  评论(0编辑  收藏  举报