TABLE

December 30, 2022 · View on GitHub

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

Synopsis

TableStmt ::=
    "TABLE" Table ( "ORDER BY" Column )? ( "LIMIT" NUM )?

Create table t1:

CREATE TABLE t1(id INT PRIMARY KEY);

Insert some data into t1:

INSERT INTO t1 VALUES (1),(2),(3);

View the data in table t1:

TABLE t1;

+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
+----+
3 rows in set (0.01 sec)

Query t1 and sort the result by the id field in descending order:

TABLE t1 ORDER BY id DESC;

+----+
| id |
+----+
|  3 |
|  2 |
|  1 |
+----+
3 rows in set (0.01 sec)

Query the first record in t1:

TABLE t1 LIMIT 1;

+----+
| id |
+----+
|  1 |
+----+
1 row in set (0.01 sec)

The TABLE statement was introduced in MySQL 8.0.19.