PHP Code-Snippet

Code

-- MySQL 8.0.19
VALUES ROW('string', 100, null), ROW('foo', 200, null);

-- SQL
VALUES ('string2', 300, null), ('foo2', 400, null);

Result

column_0	column_1	column_2
string	100	null
foo	200	null

column_0	column_1	column_2
string2	300	null
foo2	400	null

More Snippets

Used Versions

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8