SHOW TABLECOUNT
Description
SHOW TABLECOUNT returns the number of rows of all tables.
Syntax
Syntax
SHOW TABLECOUNT [<table>]
BASH
<table>
if you specify a table name, it returns the number of rows of the given table.
Output
ColumnName | description |
---|---|
schema | schema name |
table | table name |
lines | Number of rows in the table |
live_lines_without_commit | Number of rows loaded and not yet committed |