要获取特定 MySQL 数据库中的非空表列表，语法如下 –
SELECT table_type,table_name, table_schema from information_schema.tableswhere table_rows >= 1 and table_schema = 'yourDatabaseName';
为您的数据库实现上述语法。这里，我们的数据库是“test”。查询如下 –
爱图表
AI驱动的智能化图表创作平台
99 查看详情
mysql> select table_type,table_name ,table_schema from information_schema.tables−> where table_rows >= 1 and table_schema = 'test';
以下是显示数据库“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)
以上就是获取特定 MySQL 数据库中的非空表列表？的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/318314.html
微信扫一扫 
支付宝扫一扫 
