Sample Header Ad - 728x90

Does MariaDB or MySQL implement the VALUES (expression) table value constructor?

10 votes
2 answers
7970 views
I am just wondering if MariaDB or MySQL implements the ` in the SQL Spec. In [SQL Server](https://learn.microsoft.com/en-us/sql/t-sql/queries/table-value-constructor-transact-sql?view=sql-server-2017) and [PostgreSQL this is done with standardized VALUES (expression)`](https://www.postgresql.org/docs/current/static/sql-values.html) ? SELECT * FROM ( VALUES (1) ) AS t(x); x --- 1 (1 row) (syntax from [tag:postgresql]).
Asked by Evan Carroll (65502 rep)
Jun 26, 2017, 08:00 PM
Last activity: Jan 2, 2024, 11:39 PM