Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support TABLE statements #447

Open
williamdes opened this issue May 9, 2023 · 0 comments
Open

Support TABLE statements #447

williamdes opened this issue May 9, 2023 · 0 comments
Labels
enhancement kind/support A request for adding support

Comments

@williamdes
Copy link
Member

williamdes commented May 9, 2023

https://dev.mysql.com/doc/refman/8.0/en/table.html

TABLE is a DML statement introduced in MySQL 8.0.19 which returns rows and columns of the named table.

TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]

The TABLE statement in some ways acts like SELECT. Given the existence of a table named t, the following two statements produce identical output:

TABLE t;

SELECT * FROM t;

You can order and limit the number of rows produced by TABLE using ORDER BY and LIMIT clauses, respectively. These function identically to the same clauses when used with SELECT (including an optional OFFSET clause with LIMIT).

@williamdes williamdes added enhancement kind/support A request for adding support labels May 9, 2023
@williamdes williamdes added this to the 5.8.0 milestone May 9, 2023
@williamdes williamdes assigned williamdes and unassigned williamdes May 9, 2023
@williamdes williamdes removed this from the 5.8.0 milestone May 9, 2023
williamdes added a commit that referenced this issue May 9, 2023
Signed-off-by: William Desportes <williamdes@wdes.fr>
Tithugues added a commit to Tithugues/sql-parser that referenced this issue Jun 5, 2023
Tithugues added a commit to Tithugues/sql-parser that referenced this issue Jun 5, 2023
@williamdes williamdes linked a pull request Jun 5, 2023 that will close this issue
1 task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement kind/support A request for adding support
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant