Dapatkan senarai jadual bukan kosong dalam pangkalan data MySQL tertentu?

Untuk mendapatkan senarai jadual bukan kosong dalam pangkalan data MySQL tertentu, sintaksnya adalah seperti berikut -

SELECT table_type,table_name, table_schema from information_schema.tables
where table_rows >= 1 and table_schema = 'yourDatabaseName';

Laksanakan sintaks di atas untuk pangkalan data anda. Di sini, pangkalan data kami ialah "ujian". Pertanyaannya adalah seperti berikut -

mysql> select table_type,table_name ,table_schema from information_schema.tables
−> where table_rows >= 1 and table_schema = 'test';

Berikut ialah output yang menunjukkan jadual tidak kosong dalam pangkalan data "ujian" -

+------------+------------------------------+--------------+
| 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)

Atas ialah kandungan terperinci Dapatkan senarai jadual bukan kosong dalam pangkalan data MySQL tertentu?. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!