linux mysql shell 导数

linux mysql shell 导数

IT小君   2020-12-28T20:25:32
rm -rf ^bt_*

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel flight_order_base_info > bt_flight_order_base_info.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel flight_order_settlement_base_info > bt_fpsbi.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel flight_order_passenger > bt_flight_order_passenger.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel order_flight_info > bt_order_flight_info.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel order_fee > bt_order_fee.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel settlement_detail > bt_settlement_detail.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel settlement_order_detail > bt_settlement_order_detail.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel settlement_client_detail > bt_settlement_client_detail.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where='batchNo="20201101"' businesstravel settlement_hotel_detail > bt_settlement_hotel_detail.sql


mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no  journeyid from settlement_order_detail sod  where batchNo='20201101' )" businesstravel oa_apply > bt_oa_apply.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no  journeyid from settlement_order_detail sod  where batchNo='20201101' )" businesstravel trip_user > bt_trip_user.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no  journeyid from settlement_order_detail sod  where batchNo='20201101' )" businesstravel hotel_trip_info > bt_hotel_trip_info.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no  journeyid from settlement_order_detail sod  where batchNo='20201101' )" businesstravel flight_trip_info > bt_flight_trip_info.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no  journeyid from settlement_order_detail sod  where batchNo='20201101' )" businesstravel flight_order > bt_flight_order.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no  journeyid from settlement_order_detail sod  where batchNo='20201101' )" businesstravel hotel_order > bt_hotel_order.sql
mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers  --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no  journeyid from settlement_order_detail sod  where batchNo='20201101' )" businesstravel oa_expenses > bt_oa_expenses.sql


分享到:
评论(0)