MySQL显示表按表名排序？
您可以使用ORDERBY子句对INFORMATION_SCHEMA.TABLES中的table_name属性进行排序。分别借助ASC或DESC以升序或降序排序。语法如下-
SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema='yourDatabaseName' ORDER BY table_name DESC;
将数据库与名称示例一起使用，并具有一些表。首先，我们将显示所有表，之后我们将对表名进行排序。显示所有表的查询如下-
mysql> show tables;
以下是输出-
+--------------------------+ | Tables_in_sample | +--------------------------+ | blobsizedemo | | insert_prevent | | insertrecord_selecttable | | insertrecordprevent | | mytable | | newlinedemo | | notequaloperator | | sumofeverydistinct | | yourtable | +--------------------------+ 9 rows in set (0.00 sec)
这是按表名排序的查询。现在，让我们使用ORDERBY子句以降序显示所有表-
mysql> SELECT table_name -> FROM information_schema.tables -> WHERE table_type = 'BASE TABLE' AND table_schema='sample' -> ORDER BY table_name DESC;
以下是输出-
+--------------------------+ | TABLE_NAME | +--------------------------+ | yourtable | | sumofeverydistinct | | notequaloperator | | newlinedemo | | mytable | | insertrecordprevent | | insertrecord_selecttable | | insert_prevent | | blobsizedemo | +--------------------------+ 9 rows in set (0.00 sec)