Description

williamdes

opened on May 9, 2023

Issue body actions

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).

Activity

1. williamdes

   added

   enhancement

   kind/supportA request for adding supportA request for adding support

   on May 9, 2023
2. williamdes

   added this to the 5.8.0 milestone on May 9, 2023
3. williamdes

   assigned

   williamdes

   and unassigned

   williamdes

   on May 9, 2023
4. williamdes

   removed this from the 5.8.0 milestone on May 9, 2023
5. williamdes

   added a commit that references this issue on May 9, 2023

   Ref #447 - Add test cases for `TABLE` statements

   cddd0f1
6. Tithugues

   added 2 commits that reference this issue on Jun 5, 2023

   Fix phpmyadmin#447 Support TABLE statement

   This issue will close once commit b9c52b3 is merged into the 'master' branch.

   b9c52b3

   Fix phpmyadmin#447 Support TABLE statement

   This issue will close once commit cf9cb56 is merged into the 'master' branch.

   cf9cb56
7. williamdes

   linked a pull request that will close this issueFix #447 - Support TABLE statement #475on Jun 5, 2023

Issue actions