- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Get a list of non-empty tables in a particular MySQL database?
To get a list of non-empty tables in a particular MySQL database, the following is the syntax −
SELECT table_type,table_name, table_schema from information_schema.tables where table_rows >= 1 and table_schema = 'yourDatabaseName';
Implement the above syntax for your database. Here, our database is “test”. The query is as follows −
mysql> select table_type,table_name ,table_schema from information_schema.tables −> where table_rows >= 1 and table_schema = 'test';
The following is the output displaying the non-empty tables in the database “test” −
+------------+------------------------------+--------------+ | TABLE_TYPE | TABLE_NAME | TABLE_SCHEMA | +------------+------------------------------+--------------+ | BASE TABLE | add30minutesdemo | test | | BASE TABLE | addoneday | test | | BASE TABLE | agecalculatesdemo | test | | BASE TABLE | aliasdemo | test | | BASE TABLE | allcharacterbeforespace | test | | BASE TABLE | allownulldemo | test | | BASE TABLE | autoincrementdemo | test | | BASE TABLE | betweendatedemo | test | | BASE TABLE | bookdatedemo | test | | BASE TABLE | changecolumnpositiondemo | test | | BASE TABLE | concatenatetwocolumnsdemo | test | | BASE TABLE | cumulativesumdemo | test | | BASE TABLE | currentdatetimedemo | test | | BASE TABLE | dateasstringdemo | test | | BASE TABLE | dateformatdemo | test | | BASE TABLE | dateinsertdemo | test | | BASE TABLE | datesofoneweek | test | | BASE TABLE | datetimedemo | test | | BASE TABLE | dayofweekdemo | test | | BASE TABLE | decimaltointdemo | test | | BASE TABLE | defaultdemo | test | | BASE TABLE | deletemanyrows | test | | BASE TABLE | differencetimestamp | test | | BASE TABLE | distinctdemo | test | | BASE TABLE | employee | test | | BASE TABLE | employeedesignation | test | | BASE TABLE | findlowercasevalue | test | | BASE TABLE | generatingnumbersdemo | test | | BASE TABLE | gmailsignin | test | | BASE TABLE | groupbytwofieldsdemo | test | | BASE TABLE | groupmonthandyeardemo | test | | BASE TABLE | highestnumberdemo | test | | BASE TABLE | ifnulldemo | test | | BASE TABLE | insertignoredemo | test | | BASE TABLE | insertwithmultipleandsigle | test | | BASE TABLE | int11demo | test | | BASE TABLE | intvsintanythingdemo | test | | BASE TABLE | lasttwocharacters | test | | BASE TABLE | likebinarydemo | test | | BASE TABLE | likedemo | test | | BASE TABLE | maxlengthfunctiondemo | test | | BASE TABLE | newtableduplicate | test | | BASE TABLE | notequalsdemo | test | | BASE TABLE | nowandcurdatedemo | test | | BASE TABLE | nthrecorddemo | test | | BASE TABLE | nullandemptydemo | test | | BASE TABLE | orderbycharacterlength | test | | BASE TABLE | orderbynullfirstdemo | test | | BASE TABLE | orderindemo | test | | BASE TABLE | originaltable | test | | BASE TABLE | parsedatedemo | test | | BASE TABLE | passinganarraydemo | test | | BASE TABLE | prependstringoncolumnname | test | | BASE TABLE | pricedemo | test | | BASE TABLE | queryresultdemo | test | | BASE TABLE | replacedemo | test | | BASE TABLE | rowexistdemo | test | | BASE TABLE | rowpositiondemo | test | | BASE TABLE | rowwithsamevalue | test | | BASE TABLE | safedeletedemo | test | | BASE TABLE | searchtextdemo | test | | BASE TABLE | selectdataonyearandmonthdemo | test | | BASE TABLE | selectdistincttwocolumns | test | | BASE TABLE | skiplasttenrecords | test | | BASE TABLE | stringreplacedemo | test | | BASE TABLE | stringtodate | test | | BASE TABLE | student | test | | BASE TABLE | studentdemo | test | | BASE TABLE | studentmodifytabledemo | test | | BASE TABLE | studenttable | test | | BASE TABLE | subtract3hours | test | | BASE TABLE | temporarycolumnwithvaluedemo | test | | BASE TABLE | timetosecond | test | | BASE TABLE | timetoseconddemo | test | | BASE TABLE | toggledemo | test | | BASE TABLE | toogledemo | test | | BASE TABLE | updatevalueincrementally | test | | BASE TABLE | wheredemo | test | | BASE TABLE | wholewordmatchdemo | test | | BASE TABLE | zipcodepadwithzerodemo +------------+------------------------------+--------------+ 80 rows in set (0.00 sec)
Updated on 30-Jul-2019 22:30:24
- Related Questions & Answers
- List of non-empty tables in all your MySQL databases?
- How can we get the list of tables in a particular database from MySQL Server command line?
- How to get the list of tables in default MySQL database?
- How to check table status of the tables in a particular MySQL database?
- List down all the Tables in a MySQL Database
- Create a procedure to list the tables with detailed information in a particular database.
- Get a list of Constraints from MySQL Database?
- How Can I check the size of the tables in a particular MySQL database?
- How to get the size of the tables of a MySQL database?
- How can we analyze the tables of a particular database from MySQL Server command line?
- How can we check the character set of all the tables in a particular MySQL database?
- Create a MySQL stored procedure, which takes the name of the database as its parameter, to list the tables with detailed information in a particular database.
- How can we see the list of views stored in a particular MySQL database?
- Create a stored procedure to get the detail of a particular MySQL table stored in a database?
- Get record count for all tables in MySQL database?
Advertisements