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
Original: https://www.cnblogs.com/sunfankun/p/16329265.html
Author: 孙犯困
Title: bash怎么调用sql并保存结果
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/583112/
转载文章受原作者版权保护。转载请注明原作者出处!