phpmyadmin / phpmyadmin/sql-parser
Support `TABLE` statements
Nobody has claimed this yet.
- #475 by @Tithugues — closed without merging
- Dominant language
- PHP
- Stars
- 485
- Forks
- 119
- PR merge metrics
- No merged PRs in 30d
Description
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).
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files or tests are identified in the issue. Start by reading the parser's existing SELECT handling and the MySQL TABLE syntax shown here; done means TABLE statements, including ORDER BY, LIMIT, and OFFSET, are accepted with behavior matching the documented forms.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100