Last week at the MariaDB/MySQL Developer Training we had one participant asking some tricky questions I did not know the answer by heart.
Also MariaDB documentation was not too verbose (here and here).
So time to do some experiments:
Prepared Statements and Multi-Row Inserts
SQL> PREPARE stmt1 FROM 'INSERT INTO `test`.`test` (`data`) VALUES (?), (?), (?)';
Statement prepared
SQL> SET @d1 = 'Bli';
SQL> SET @d2 = 'Bla';
SQL> SET @d3 = 'Blub';
SQL> EXECUTE stmt1 USING @d1, @d2, @d3;
Query OK, 3 …
