martes, 9 de junio de 2020

Listar el numero de resgitros de tablas de una base de datos

mysql> SELECT table_name as tablas, table_rows as registros FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'ebdb';                                         +--------------------------+-----------+
| tablas                   | registros |
+--------------------------+-----------+
| wp_cf_form_entries       |    133859 |
| wp_cf_form_entry_meta    |         0 |
| wp_cf_form_entry_values  |    801966 |
| wp_cf_tracking           |         0 |
| wp_cf_tracking_meta      |         0 |
| wp_commentmeta           |         0 |
| wp_comments              |         0 |
| wp_dlm_order             |         0 |
| wp_dlm_order_customer    |         0 |
| wp_dlm_order_item        |         0 |
| wp_dlm_order_transaction |         0 |
| wp_dlm_session           |         0 |
| wp_download_log          |        27 |
| wp_ine_activity_conf_log |         0 |
| wp_ine_activity_log      |    103685 |
| wp_links                 |         0 |
| wp_options               |    110724 |
| wp_postmeta              |    280516 |
| wp_posts                 |     59708 |
| wp_redirection_404       |    114932 |
| wp_redirection_groups    |         2 |
| wp_redirection_items     |        68 |
| wp_redirection_logs      |      6851 |
| wp_responsive_menu       |       279 |
| wp_term_relationships    |      2271 |
| wp_term_taxonomy         |       396 |
| wp_termmeta              |        38 |
| wp_terms                 |       396 |
| wp_usermeta              |      2701 |
| wp_users                 |        71 |
+--------------------------+-----------+
30 rows in set (0.00 sec)

No hay comentarios:

Publicar un comentario