SHOW TABLECOUNT
Description
SHOW TABLECOUNT returns the number of rows of all tables.
Syntax
Syntax
BASH
SHOW TABLECOUNT [<table>] <table>
When you define a table, it returns the number of rows of the given table.
Output
| ColumnName | description |
|---|---|
| schema | schema name |
| table | table name |
| lines | Number of rows |