TABLE

The TABLE statement can be used instead of SELECT * FROM when no aggregation or complex filtering is needed.

Synopsis

TableStmt
TABLETableORDER BYColumnLIMITNUM

Examples

CREATE TABLE t1(id INT PRIMARY KEY);
Query OK, 0 rows affected (0.31 sec)
INSERT INTO t1 VALUES (1),(2),(3);
Query OK, 3 rows affected (0.06 sec) Records: 3 Duplicates: 0 Warnings: 0
TABLE t1;
+----+ | id | +----+ | 1 | | 2 | | 3 | +----+ 3 rows in set (0.01 sec)
TABLE t1 ORDER BY id DESC;
+----+ | id | +----+ | 3 | | 2 | | 1 | +----+ 3 rows in set (0.01 sec)
TABLE t1 LIMIT 1;
+----+ | id | +----+ | 1 | +----+ 1 row in set (0.01 sec)

MySQL compatibility

The TABLE statement was introduced in MySQL 8.0.19.

See also