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)
martes, 9 de junio de 2020
Listar el numero de resgitros de tablas de una base de datos
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario