SHOW TABLE NEXT_ROW_ID
SHOW TABLE NEXT_ROW_ID
is used to show the details of some special columns of a table, including:
AUTO_INCREMENT
column automatically created by TiDB, namely,_tidb_rowid
column.AUTO_INCREMENT
column created by users.AUTO_RANDOM
column created by users.SEQUENCE
created by users.
Synopsis
ShowTableNextRowIDStmt:
TableName:
Examples
For newly created tables, NEXT_GLOBAL_ROW_ID
is 1
because no Row ID is allocated.
create table t(a int);
Query OK, 0 rows affected (0.06 sec)
show table t next_row_id;
+---------+------------+-------------+--------------------+
| DB_NAME | TABLE_NAME | COLUMN_NAME | NEXT_GLOBAL_ROW_ID |
+---------+------------+-------------+--------------------+
| test | t | _tidb_rowid | 1 |
+---------+------------+-------------+--------------------+
1 row in set (0.00 sec)
Data have been written to the table. The TiDB server that inserts the data allocates and caches 30000 IDs at once. Thus, NEXT_GLOBAL_ROW_ID is 30001 now.
insert into t values (), (), ();
Query OK, 3 rows affected (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 0
show table t next_row_id;
+---------+------------+-------------+--------------------+
| DB_NAME | TABLE_NAME | COLUMN_NAME | NEXT_GLOBAL_ROW_ID |
+---------+------------+-------------+--------------------+
| test | t | _tidb_rowid | 30001 |
+---------+------------+-------------+--------------------+
1 row in set (0.00 sec)
MySQL compatibility
This statement is a TiDB extension to MySQL syntax.