'MySQL values statement as a parameter?

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?

mysqlsqldatabasemysql-workbenchrubyapigrape-apiapi-versioning


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions