Snippet: Update row columns with where clause in a mysql table

Update row columns with where clause in a mysql table

Tommy — tomcw

Example mysql query statement function to update row columns with a where clause in mysql 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 e.g. column_1 could be a unique row id
async function updateRowColumns(values) {
  let query = await lib.mysql.db['@0.2.1'].query({ 
    query: 'UPDATE `table_name` SET `column_2` = ?, `column_3` = ?, `column_5` = ? WHERE `column_1` = ?',
    values: values
  });
  return query
};

// values for each consecutive question mark ? in the statement
let values = ['value_1','value_2','value_3','value_4'];

// execute
await updateRowColumns(values);