Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
List of non-empty tables in all your MySQL databases?
To list non-empty tables in MySQL database, use “information_schema.tables”. The following is the query for all database tables −
mysql> select table_type, table_name from information_schema.tables −> where table_rows >= 1;
Above, we have considered only the table that have 1 or more than 1 rows i.e. non-empty table.
The following is the output −
+------------+------------------------------------------------------+ | TABLE_TYPE | TABLE_NAME | +------------+------------------------------------------------------+ | BASE TABLE | innodb_table_stats | | BASE TABLE | innodb_index_stats | | BASE TABLE | cond_instances | | BASE TABLE | events_waits_current | | BASE TABLE | events_waits_history | | BASE TABLE | events_waits_history_long | | BASE TABLE | events_waits_summary_by_host_by_event_name | | BASE TABLE | events_waits_summary_by_instance | | BASE TABLE | events_waits_summary_by_thread_by_event_name | | BASE TABLE | events_waits_summary_by_user_by_event_name | | BASE TABLE | events_waits_summary_by_account_by_event_name | | BASE TABLE | events_waits_summary_global_by_event_name | | BASE TABLE | file_instances | | BASE TABLE | file_summary_by_event_name | | BASE TABLE | file_summary_by_instance | | BASE TABLE | host_cache | | BASE TABLE | mutex_instances | | BASE TABLE | objects_summary_global_by_type | | BASE TABLE | performance_timers | | BASE TABLE | rwlock_instances | | BASE TABLE | setup_actors | | BASE TABLE | setup_consumers | | BASE TABLE | setup_instruments | | BASE TABLE | setup_objects | | BASE TABLE | setup_threads | | BASE TABLE | table_io_waits_summary_by_index_usage | | BASE TABLE | table_io_waits_summary_by_table | | BASE TABLE | table_lock_waits_summary_by_table | | BASE TABLE | threads | | BASE TABLE | events_stages_current | | BASE TABLE | events_stages_history | | BASE TABLE | events_stages_history_long | | BASE TABLE | events_stages_summary_by_thread_by_event_name | | BASE TABLE | events_stages_summary_by_account_by_event_name | | BASE TABLE | events_stages_summary_by_user_by_event_name | | BASE TABLE | events_stages_summary_by_host_by_event_name | | BASE TABLE | events_stages_summary_global_by_event_name | | BASE TABLE | events_statements_current | | BASE TABLE | events_statements_history | | BASE TABLE | events_statements_history_long | | BASE TABLE | events_statements_summary_by_thread_by_event_name | | BASE TABLE | events_statements_summary_by_account_by_event_name | | BASE TABLE | events_statements_summary_by_user_by_event_name | | BASE TABLE | events_statements_summary_by_host_by_event_name | | BASE TABLE | events_statements_summary_global_by_event_name | | BASE TABLE | events_statements_summary_by_digest | | BASE TABLE | events_statements_histogram_global | | BASE TABLE | events_statements_histogram_by_digest | | BASE TABLE | events_transactions_current | | BASE TABLE | events_transactions_history | | BASE TABLE | events_transactions_history_long | | BASE TABLE | events_transactions_summary_by_thread_by_event_name | | BASE TABLE | events_transactions_summary_by_account_by_event_name | | BASE TABLE | events_transactions_summary_by_user_by_event_name | | BASE TABLE | events_transactions_summary_by_host_by_event_name | | BASE TABLE | events_transactions_summary_global_by_event_name | | BASE TABLE | events_errors_summary_by_user_by_error | | BASE TABLE | events_errors_summary_by_host_by_error | | BASE TABLE | events_errors_summary_by_account_by_error | | BASE TABLE | events_errors_summary_by_thread_by_error | | BASE TABLE | events_errors_summary_global_by_error | | BASE TABLE | users | | BASE TABLE | accounts | | BASE TABLE | hosts | | BASE TABLE | socket_instances | | BASE TABLE | socket_summary_by_instance | | BASE TABLE | socket_summary_by_event_name | | BASE TABLE | session_connect_attrs | | BASE TABLE | session_account_connect_attrs | | BASE TABLE | memory_summary_global_by_event_name | | BASE TABLE | memory_summary_by_account_by_event_name | | BASE TABLE | memory_summary_by_host_by_event_name | | BASE TABLE | memory_summary_by_thread_by_event_name | | BASE TABLE | memory_summary_by_user_by_event_name | | BASE TABLE | table_handles | | BASE TABLE | metadata_locks | | BASE TABLE | data_locks | | BASE TABLE | data_lock_waits | | BASE TABLE | replication_connection_configuration | | BASE TABLE | replication_connection_status | | BASE TABLE | replication_applier_configuration | | BASE TABLE | replication_applier_status | | BASE TABLE | replication_applier_status_by_coordinator | | BASE TABLE | replication_applier_status_by_worker | | BASE TABLE | log_status | | BASE TABLE | user_variables_by_thread | | BASE TABLE | status_by_account | | BASE TABLE | status_by_host | | BASE TABLE | status_by_thread | | BASE TABLE | status_by_user | | BASE TABLE | global_status | | BASE TABLE | session_status | | BASE TABLE | variables_by_thread | | BASE TABLE | global_variables | | BASE TABLE | session_variables | | BASE TABLE | variables_info | | BASE TABLE | user_defined_functions | | BASE TABLE | db | | BASE TABLE | user | | BASE TABLE | global_grants | | BASE TABLE | tables_priv | | BASE TABLE | help_topic | | BASE TABLE | help_category | | BASE TABLE | help_relation | | BASE TABLE | help_keyword | | BASE TABLE | general_log | | BASE TABLE | slow_log | | BASE TABLE | server_cost | | BASE TABLE | engine_cost | | BASE TABLE | proxies_priv | | BASE TABLE | sys_config | | BASE TABLE | primarytable | | BASE TABLE | tblstudent | | BASE TABLE | groupdemo | | BASE TABLE | nthrecorddemo | | BASE TABLE | intdemo | | BASE TABLE | demo | | BASE TABLE | student | | BASE TABLE | moviecollection | | BASE TABLE | bookindexes | | BASE TABLE | duplicatebookindexes | | BASE TABLE | existsrowdemo | | BASE TABLE | demoascii | | BASE TABLE | primarytable1 | | BASE TABLE | foreigntable | | BASE TABLE | autoincrementtable | | BASE TABLE | demoauto | | BASE TABLE | demoonreplace | | BASE TABLE | whereconditon | | BASE TABLE | moneydemo | | BASE TABLE | presenthistory | | BASE TABLE | pasthistory | | BASE TABLE | columnvaluenulldemo | | BASE TABLE | nonasciidemo | | BASE TABLE | nullwithselect | | BASE TABLE | autoincrement | | BASE TABLE | unsigneddemo | | BASE TABLE | university | | BASE TABLE | student | | BASE TABLE | distinctdemo | | BASE TABLE | groupdemo1 | | BASE TABLE | incasesensdemo | | BASE TABLE | spacecolumn | | BASE TABLE | primarytabledemo | | BASE TABLE | foreigntabledemo | | BASE TABLE | trailingandleadingdemo | | BASE TABLE | duplicatefound | | BASE TABLE | sequencedemo | | BASE TABLE | findandreplacedemo | | BASE TABLE | limitoffsetdemo | | BASE TABLE | deletedemo | | BASE TABLE | deleterecord | | BASE TABLE | clonestudent | | BASE TABLE | secondtable | | BASE TABLE | rowstranspose | | BASE TABLE | rowstransposedemo | | BASE TABLE | rownumberdemo | | BASE TABLE | tblfirst | | BASE TABLE | updtable | | BASE TABLE | transcationdemo | | BASE TABLE | limitdemo | | BASE TABLE | rowcountdemo | | BASE TABLE | addconstraintdemo | | BASE TABLE | imagedemo | | BASE TABLE | tblifdemo | | BASE TABLE | tblupdatelimit | | BASE TABLE | sortingvarchardemo | | BASE TABLE | backticksymbol | | BASE TABLE | qutesdemo | | BASE TABLE | ondemo | | BASE TABLE | ifelsedemo | | BASE TABLE | demowhere | | BASE TABLE | usernameandpassworddemo | | BASE TABLE | tbldemotrail | | BASE TABLE | tblselectdemo | | BASE TABLE | commaseperatedemo | | BASE TABLE | nextpreviousdemo | | BASE TABLE | multiplerecordwithvalues | | BASE TABLE | distinctdemo1 | | BASE TABLE | addnotnulldemo | | BASE TABLE | uniquedemo | | BASE TABLE | uniqueconstdemo | | BASE TABLE | distcountdemo | | BASE TABLE | trimdemo | | BASE TABLE | keydemo | | BASE TABLE | singlequotesdemo | | BASE TABLE | groupt_concatdemo | | BASE TABLE | groupconcatenatedemo | | BASE TABLE | table1 | | BASE TABLE | table2 | | BASE TABLE | sourcetable | | BASE TABLE | originaltable | | BASE TABLE | originaltable | | BASE TABLE | saveintotextfile | | BASE TABLE | studenttable | | BASE TABLE | uniondemo1 | | BASE TABLE | uniondemo2 | | BASE TABLE | repairtabledemo | | BASE TABLE | proctabledemo | | BASE TABLE | enumdemo | | BASE TABLE | nextiddemo | | BASE TABLE | firsttabledemo | | BASE TABLE | secondtabledemo | | BASE TABLE | duplicatedeletedemo | | BASE TABLE | variableastablename | | BASE TABLE | numberofcolumns | | BASE TABLE | randoptimizedemo | | BASE TABLE | randomoptimizationdemo | | BASE TABLE | last10recordsdemo | | BASE TABLE | bitdemo | | BASE TABLE | tinyintdemo | | BASE TABLE | uniquedemo1 | | BASE TABLE | lowcardinality | | BASE TABLE | columnnameasnumberdemo | | BASE TABLE | jasonasmysqldemo | | BASE TABLE | insubquerydemo | | BASE TABLE | orderdemo | | BASE TABLE | rowintocolumn | | BASE TABLE | finddemo | | BASE TABLE | uniqueautoid | | BASE TABLE | countrycitydemo | | BASE TABLE | employeeinformation | | BASE TABLE | addingunique | | BASE TABLE | currenttimezone | | BASE TABLE | add1daydemo | | BASE TABLE | columnnamewithspace | | BASE TABLE | prependstringoncolumnname | | BASE TABLE | passinganarraydemo | | BASE TABLE | rowexistdemo | | BASE TABLE | wheredemo | | BASE TABLE | mytabledemo | | BASE TABLE | textintonumberdemo | | BASE TABLE | swappingtwocoulmnsvaluedemo | | BASE TABLE | checkingintegerdemo | | BASE TABLE | myisamtabledemo | | BASE TABLE | insertwithmultipleandsigle | | BASE TABLE | updatewithlimit | | BASE TABLE | lastinsertiddemo | | BASE TABLE | lastinsertrecordiddemo | | BASE TABLE | datetimedemo | | BASE TABLE | rowvaluedemo | | BASE TABLE | adding5hours | | BASE TABLE | stringoccurrencedemo | | BASE TABLE | varchartointdemo | | BASE TABLE | getlastrecord | | BASE TABLE | rankdemo | | BASE TABLE | iddemo | | BASE TABLE | replacedemo | | BASE TABLE | addingautoincrement | | BASE TABLE | samevaluedemo | | BASE TABLE | groupbydemo | | BASE TABLE | product | | BASE TABLE | nulldemowithzero | | BASE TABLE | updateatinsert | | BASE TABLE | updateatinsertdemo | | BASE TABLE | int11demo | | BASE TABLE | allownulldemo | | BASE TABLE | zerofilldemo | | BASE TABLE | sortingdemo | | BASE TABLE | uniqueconstrainttable | | BASE TABLE | insertdemo | | BASE TABLE | deletetabledemo | | BASE TABLE | updatedemo | | BASE TABLE | nestedtransactiondemo | | BASE TABLE | javadatetimedemo | | BASE TABLE | mergedemo1 | | BASE TABLE | accentsearchdemo | | BASE TABLE | twoprimarykeytabledemo | | BASE TABLE | mysqltabledemo | | BASE TABLE | insertmultiplerowsdemo | | BASE TABLE | orderbydemo | | BASE TABLE | indemo | | BASE TABLE | unsigneddemowithpositivevalue | | BASE TABLE | nulldemo1 | | BASE TABLE | insertvaluesandsetdemo | | BASE TABLE | toomanyfieldsreturndemo | | BASE TABLE | limitoffsettable | | BASE TABLE | ifelsecasedemo | | BASE TABLE | autoincrementtozero | | BASE TABLE | replacenullwithzerodemo | | BASE TABLE | floordemo | | BASE TABLE | greatestoftwoormore | | BASE TABLE | altertabletoaddautoincrement | | BASE TABLE | selectinwithbetweendemo | | BASE TABLE | moneystoragedemo | | BASE TABLE | inwithfielddemo | | BASE TABLE | selectintodemo | | BASE TABLE | yourtemptable | | BASE TABLE | nullandemptydemo | | BASE TABLE | dateasstringdemo
Updated on: 30-Jul-2019595 Views
Advertisements