mysql> select table_name,table_rows from tables
-> where TABLE_SCHEMA = ‘xdf_wechat’
-> order by table_rows desc;
+————————————————+————+
| table_name | table_rows |
+————————————————+————+
| wechat_questionnaire_users_answers_content | 8056673 |
| xdf_custom_qrcode_scancode_statistics | 3051402 |
| wechat_users_location | 2952246 |
| wechat_users | 1723989 |
| wechat_template_message_log | 1314947 |
mysql 查看所有表的数据行数
最新推荐文章于 2024-04-28 16:20:18 发布