CODEWITHSUNDEEP
mysql
dvv
dvv

Reputation: 741

MySQL analog of PostgreSQL VALUES statement?

In PostgreSQL we have VALUES statement.

For example, 

VALUES (1, 'one'), (2, 'two'), (3, 'three');

is equivalent to

SELECT 1 AS column1, 'one' AS column2
UNION ALL
SELECT 2, 'two'
UNION ALL
SELECT 3, 'three';

What is analog in MySQL?

Upvotes: 3

Views: 203

Answers (1)

user330315
user330315

Reputation:

MySQL does not support the (standard) row constructor using VALUES. It is supported for an INSERT statement, but never as a "standalone" statement.

Upvotes: 1

Related Questions