Example mysql query statement function to delete rows with a where clause from 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 deleteRows(values) {
let query = await lib.mysql.db['@0.2.1'].query({
query: 'DELETE FROM `table_name` WHERE (`column_1`,`column_2`,`column_3`,`column_4`) IN (?)',
values: [values]
});
return query
};
// values you want to check where clause against to delete row from table
let values = [
['value_1','value_2','value_3','value_4'],
['value_1','value_2','value_3','value_4'],
['value_1','value_2','value_3','value_4'],
];
// execute
await deleteRows(values);