Snippet: Insert multiple rows into a mysql table

Insert multiple rows into a mysql table

Tommy — tomcw

Example mysql query statement function to insert a multiple rows into a table. Couldn't find any examples of MySQL queries using the autocode api when I wanted so made some simple examples.

const lib = require('lib')({token: process.env.STDLIB_SECRET_TOKEN});

// change table and column name values accordingly
async function insertMultipleRows(values) {
  let query = await lib.mysql.db['@0.2.1'].query({ 
    query: 'INSERT INTO `table_name` (column_1,column_2,column_3,column_4,column_5) VALUES ?',
    values: [values]
  });
  return query
};

// values you want to insert into each column per row
let values = [
  ['value_1','value_2','value_3','value_4','value_5'],
  ['value_1','value_2','value_3','value_4','value_5'],
  ['value_1','value_2','value_3','value_4','value_5'],
];

// execute
await insertMultipleRows(values);