spawn scp -o StrictHostKeyChecking=no /tmp/csfzx_verify_load.sql opsuser@8.147.119.215:/tmp/csfzx_verify_load.sql

opsuser@8.147.119.215's password:

csfzx_verify_load.sql                           0%    0     0.0KB/s   --:-- ETA
csfzx_verify_load.sql                         100% 1452    90.5KB/s   00:00
spawn ssh -o StrictHostKeyChecking=no opsuser@8.147.119.215 su - root -c 'mysql -h127.0.0.1 -P2883 -u"zhct_user@sys#city_subcenter_ob" -p"Zhct_OB_20260615" --table < /tmp/csfzx_verify_load.sql'

opsuser@8.147.119.215's password:
Password: T8bN!3vGx$6jHy%1c
mysql: [Warning] Using a password on the command line interface can be insecure.
+---------------------------------+------+
| tag                             | cnt  |
+---------------------------------+------+
| load_staff_plate                | 1500 |
| load_meal_order                 | 1500 |
| load_initial_menu               | 1500 |
| load_order_total_price_positive | 1500 |
| load_initial_price_positive     | 1500 |
+---------------------------------+------+
+----------------+--------+--------+
| equipment_code | orders | amount |
+----------------+--------+--------+
| CSFZX460001    |     25 |  12.00 |
| CSFZX460002    |     25 |  97.50 |
| CSFZX460003    |     25 | 105.00 |
| CSFZX460004    |     25 |  18.75 |
| CSFZX460005    |     25 | 426.75 |
| CSFZX460006    |     25 |  90.00 |
| CSFZX460007    |     25 | 130.00 |
| CSFZX460008    |     25 |  28.00 |
| CSFZX460009    |     25 | 187.50 |
| CSFZX460010    |     25 |  32.00 |
| CSFZX460011    |     25 |  60.00 |
| CSFZX460012    |     25 |  62.00 |
| CSFZX460013    |     25 | 175.00 |
| CSFZX460014    |     25 |  37.50 |
| CSFZX460015    |     25 | 285.75 |
| CSFZX460016    |     25 | 348.75 |
| CSFZX460017    |     25 | 144.50 |
| CSFZX460018    |     25 | 194.50 |
| CSFZX460019    |     25 |  50.00 |
| CSFZX460020    |     25 | 250.00 |
| CSFZX460021    |     25 | 266.75 |
| CSFZX460022    |     25 | 286.75 |
| CSFZX460023    |     25 | 126.50 |
| CSFZX460024    |     25 | 187.50 |
| CSFZX460025    |     25 | 277.75 |
| CSFZX460026    |     25 | 152.00 |
| CSFZX460027    |     25 |  32.50 |
| CSFZX460028    |     25 | 364.50 |
| CSFZX460029    |     25 | 150.00 |
| CSFZX460030    |     25 | 120.00 |
| CSFZX460031    |     25 | 112.50 |
| CSFZX460032    |     25 | 130.00 |
| CSFZX460033    |     25 | 100.00 |
| CSFZX460034    |     25 |  85.75 |
| CSFZX460035    |     25 | 160.00 |
| CSFZX460036    |     25 | 160.00 |
| CSFZX460037    |     25 |  23.25 |
| CSFZX460038    |     25 | 140.00 |
| CSFZX460039    |     25 |  23.50 |
| CSFZX460040    |     25 | 200.00 |
| CSFZX460041    |     25 | 210.50 |
| CSFZX460042    |     25 |  26.00 |
| CSFZX460043    |     25 |  17.50 |
| CSFZX460044    |     25 |  60.00 |
| CSFZX460045    |     25 |  32.00 |
| CSFZX460046    |     25 |  30.00 |
| CSFZX460047    |     25 | 123.75 |
| CSFZX460048    |     25 | 170.75 |
| CSFZX460049    |     25 | 187.50 |
| CSFZX460050    |     25 | 160.00 |
| CSFZX460051    |     25 | 281.25 |
| CSFZX460052    |     25 |  97.50 |
| CSFZX460053    |     25 | 437.50 |
| CSFZX460054    |     25 | 150.00 |
| CSFZX460055    |     25 |  84.25 |
| CSFZX460056    |     25 |  90.00 |
| CSFZX460057    |     25 | 162.50 |
| CSFZX460058    |     25 | 203.50 |
| CSFZX460059    |     25 | 111.00 |
| CSFZX460060    |     25 | 120.00 |
+----------------+--------+--------+
+----+-----------------+---------+----------------+-------------+-------------+---------------------+
| id | order_no        | bind_id | equipment_code | total_price | meal_number | bind_time           |
+----+-----------------+---------+----------------+-------------+-------------+---------------------+
|  6 | 260622181900001 |      12 | CSFZX460004    |        0.75 |           1 | 2026-06-22 18:19:41 |
|  7 | 260622181900002 |      11 | CSFZX460009    |        7.50 |           1 | 2026-06-22 18:19:41 |
|  8 | 260622181900003 |      15 | CSFZX460002    |        3.90 |           1 | 2026-06-22 18:19:41 |
|  9 | 260622181900004 |      14 | CSFZX460005    |       17.07 |           1 | 2026-06-22 18:19:41 |
| 10 | 260622181900005 |      13 | CSFZX460003    |        4.20 |           1 | 2026-06-22 18:19:41 |
+----+-----------------+---------+----------------+-------------+-------------+---------------------+
+----+-----------------------+----------------+--------+-------------+---------------------+
| id | plate_code            | equipment_code | weight | total_price | meal_time           |
+----+-----------------------+----------------+--------+-------------+---------------------+
| 10 | CSFZX_PLATE_LOAD_0009 | CSFZX460009    | 150    |        7.50 | 2026-06-22 18:19:43 |
| 11 | CSFZX_PLATE_LOAD_0020 | CSFZX460020    | 160    |       10.00 | 2026-06-22 18:19:43 |
| 12 | CSFZX_PLATE_LOAD_0005 | CSFZX460005    | 160    |       17.07 | 2026-06-22 18:19:43 |
| 13 | CSFZX_PLATE_LOAD_0002 | CSFZX460002    | 130    |        3.90 | 2026-06-22 18:19:43 |
| 14 | CSFZX_PLATE_LOAD_0004 | CSFZX460004    | 150    |        0.75 | 2026-06-22 18:19:43 |
+----+-----------------------+----------------+--------+-------------+---------------------+