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

opsuser@8.147.119.215's password:

csfzx_final_device_verify.sql                   0%    0     0.0KB/s   --:-- ETA
csfzx_final_device_verify.sql                 100% 1165    59.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_final_device_verify.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  |
+-------------------------+------+
| equipment_total         |   60 |
| equipment_paired        |   60 |
| equipment_heartbeat_60s |   60 |
| push_dishes_records     |  120 |
| mq_type2_records        |   60 |
| mq_log_type2_records    |   60 |
+-------------------------+------+
+------+--------+------+
| type | status | cnt  |
+------+--------+------+
|    2 |      1 |   60 |
+------+--------+------+
+-------------+-----------------------------------+-----------+------------+--------------------------------------+---------------------+
| code        | name                              | mate_flag | hearttime  | left_dishes_uuid                     | push_dishes_time    |
+-------------+-----------------------------------+-----------+------------+--------------------------------------+---------------------+
| CSFZX460001 | 城市副中心460测试设备001          |         1 | 1782123303 | AA73F1A1-B2BE-376C-9781-574CDD3FF821 | 2026-06-22 18:15:08 |
| CSFZX460002 | 城市副中心460测试设备002          |         1 | 1782123303 | C255181D-AEE0-EBC3-C319-75182A2D968E | 2026-06-22 18:15:08 |
| CSFZX460003 | 城市副中心460测试设备003          |         1 | 1782123303 | 83A76F46-1407-66CE-9117-07394F813790 | 2026-06-22 18:15:08 |
| CSFZX460004 | 城市副中心460测试设备004          |         1 | 1782123303 | 94BE12B8-9253-4906-CCB1-1E6B1185AF3D | 2026-06-22 18:15:08 |
| CSFZX460005 | 城市副中心460测试设备005          |         1 | 1782123303 | 75A89EE1-15AB-C4DA-FB20-0E23ED6151A1 | 2026-06-22 18:15:08 |
+-------------+-----------------------------------+-----------+------------+--------------------------------------+---------------------+