| 123456789101112131415161718 |
- #!/bin/bash
- dbs=()
- for i in {0..12}; do
- if [ $i -ne 1 ]; then # 跳过数字1
- dbs+=("ro${i#0}")
- fi
- done
- sql=""
- for db in "${dbs[@]}"; do
- sql+="SELECT *, '$db' as source_db FROM $db.role_order_list WHERE goods_type IN (1,3,4) UNION ALL "
- done
- # 移除最后一个 " UNION ALL "
- sql="${sql% UNION ALL }"
- echo "$sql" | mysql -u root -p'123456' | sed 's/\t/,/g' > all_orders.csv
|
