Retro Eye care Haitian Deep Dark Default

COUNT SINGLE_TABLE RULE

Description

The COUNT SINGLE TABLE syntax is used to query number of single table for specified database.

Syntax

CountSingleTable::=
  'COUNT' 'SINGLE' 'TABLE' ('FROM' databaseName)?
  
databaseName ::=
  identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Return Value Description

Column Description
database The database name where the single table is located
count The count of single table

Example

  • Query the number of single table rules for specified database.
COUNT SINGLE TABLE
mysql> COUNT SINGLE TABLE;
+----------+--------+
| database | count  |
+----------+--------+
| ds       | 2      |
+----------+--------+
1 row in set (0.02 sec)

Reserved word

COUNT, SINGLE, TABLE, FROM