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
Last activity: Jan 2, 2024, 11:39 PM