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

opsuser@8.147.119.215's password:

csfzx_verify_import.sql                         0%    0     0.0KB/s   --:-- ETA
csfzx_verify_import.sql                       100% 1651   133.8KB/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_import.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  |
+-----------------------------+------+
| staff_total                 | 1500 |
| staff_ai_synced             | 1500 |
| user_total                  | 1500 |
| staff_department            | 1500 |
| staff_card                  | 1500 |
| staff_card_log              | 1500 |
| ai_user_total               | 1500 |
| mq_type4_pending            |    0 |
| mq_type4_test_staff_pending |    0 |
| mq_type1_pending            |    0 |
+-----------------------------+------+
+------+------------------+----------------------+-------------+------------+---------+
| id   | name             | personnel_umber      | mobile      | ai_user_id | card_id |
+------+------------------+----------------------+-------------+------------+---------+
| 1501 | 测试人员0001     | CSFZX_TEST_USER_0001 | 13900000001 |          2 |         |
| 1502 | 测试人员0002     | CSFZX_TEST_USER_0002 | 13900000002 |          3 |         |
| 1503 | 测试人员0003     | CSFZX_TEST_USER_0003 | 13900000003 |          4 |         |
| 1504 | 测试人员0004     | CSFZX_TEST_USER_0004 | 13900000004 |          5 |         |
| 1505 | 测试人员0005     | CSFZX_TEST_USER_0005 | 13900000005 |          6 |         |
+------+------------------+----------------------+-------------+------------+---------+
+---------+-------------+------------+----------+-----------+
| user_id | mobile      | business   | store_id | is_delete |
+---------+-------------+------------+----------+-----------+
|       2 | 13900000001 | zhct_csfzx |    10001 |         0 |
|       3 | 13900000002 | zhct_csfzx |    10001 |         0 |
|       4 | 13900000003 | zhct_csfzx |    10001 |         0 |
|       5 | 13900000004 | zhct_csfzx |    10001 |         0 |
|       6 | 13900000005 | zhct_csfzx |    10001 |         0 |
+---------+-------------+------------+----------+-----------+