Pular para o conteúdo principal

DELETE

execute(sql, values)

execute(sql: string, values: any[])

try {
const sql = 'DELETE FROM `users` WHERE `name` = ? LIMIT 1';
const values = ['Page'];

const [result, fields] = await connection.execute(sql, values);

console.log(result);
console.log(fields);
} catch (err) {
console.log(err);
}
  • result: contains a ResultSetHeader object, which provides details about the operation executed by the server.
  • fields contains extra meta data about the operation, if available
info

The connection used for the query (execute) can be obtained through the createConnection, createPool or createPoolCluster methods.


execute(options)

execute(options: QueryOptions)

try {
const sql = 'DELETE FROM `users` WHERE `name` = ? LIMIT 1';
const values = ['Page'];

const [result, fields] = await connection.execute({
sql,
values,
// ... other options
});

console.log(result);
console.log(fields);
} catch (err) {
console.log(err);
}
  • result: contains a ResultSetHeader object, which provides details about the operation executed by the server.
  • fields contains extra meta data about the operation, if available
info

The connection used for the query (execute) can be obtained through the createConnection, createPool or createPoolCluster methods.


execute(options, values)

execute(options: QueryOptions, values: any[])

try {
const sql = 'DELETE FROM `users` WHERE `name` = ? LIMIT 1';
const values = ['Page'];

const [result, fields] = await connection.execute(
{
sql,
// ... other options
},
values
);

console.log(result);
console.log(fields);
} catch (err) {
console.log(err);
}
  • result: contains a ResultSetHeader object, which provides details about the operation executed by the server.
  • fields contains extra meta data about the operation, if available
info

The connection used for the query (execute) can be obtained through the createConnection, createPool or createPoolCluster methods.


Glossary

ResultSetHeader

ResultSetHeader Specification

QueryOptions

QueryOptions Specification