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

ColumnNamedescription
schemaschema name
tabletable name
linesNumber of rows in the table
live_lines_without_commitNumber of rows loaded and not yet committed