MySQL values statement as a parameter?

Question

is it possible to insert into a MySQL table with the whole VALUES block of code being a parameter?

Parameter would be:

  ("(638) 833-5496","[email protected]","Spain"),
  ("(293) 742-0229","[email protected]","Belgium"),
  ("1-265-156-4304","[email protected]","Ireland"),
  ("1-833-780-2553","[email protected]","France"),
  ("(619) 691-0656","[email protected]","Costa Rica");

Insert statement would be

INSERT INTO `myTable` (`phone`,`email`,`country`)
VALUES
  {parameter}

Is it possible to do as an Insert statement, stored procedure, or anything?

Check if this solves your problem [link](https://stackoverflow.com/questions/5526917/how-to-do-a-batch-insert-in-mysql) — Amit Verma, May 20 '22 at 02:52
Shown data block must be not a single parameter (which will be treated as solid string parameter and enclosed with single quotes) but a code block to be appended. — Akina, May 20 '22 at 04:19

score 0 · Accepted Answer · answered May 21 '22 at 01:29

I was able to solve this by utilizing the EXECUTE command and passing the string as a variable and then compiling it into one SQL statement.

CREATE DEFINER=`admin`@`%` PROCEDURE `insert_string_storedprocedure`(bubble_variable text)
BEGIN

set @insert_string = "INSERT INTO `myTable` 
(`phone`,`email`,`country`)
VALUES
(insert_statement)
AS new
ON DUPLICATE KEY UPDATE
email = new.email;";

set @fullcommand = REPLACE(@insert_string, '(insert_statement)', bubble_variable);

PREPARE stmt FROM @fullcommand;
EXECUTE stmt;

END

MySQL values statement as a parameter?

1 Answers1