INSERT
execute(sql, values)
execute(sql: string, values: any[])
- promise.js
- callback.js
try {
const sql = 'INSERT INTO `users`(`name`, `age`) VALUES (?, ?), (?,?)';
const values = ['Josh', 19, 'Page', 45];
const [result, fields] = await connection.execute(sql, values);
console.log(result);
console.log(fields);
} catch (err) {
console.log(err);
}
const sql = 'INSERT INTO `users`(`name`, `age`) VALUES (?, ?), (?,?)';
const values = ['Josh', 19, 'Page', 45];
connection.execute(sql, values, (err, result, fields) => {
if (err instanceof Error) {
console.log(err);
return;
}
console.log(result);
console.log(fields);
});
- 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)
- promise.js
- callback.js
try {
const sql = 'INSERT INTO `users`(`name`, `age`) VALUES (?, ?), (?,?)';
const values = ['Josh', 19, 'Page', 45];
const [result, fields] = await connection.execute({
sql,
values,
// ... other options
});
console.log(result);
console.log(fields);
} catch (err) {
console.log(err);
}
const sql = 'INSERT INTO `users`(`name`, `age`) VALUES (?, ?), (?,?)';
const values = ['Josh', 19, 'Page', 45];
connection.execute(
{
sql,
values,
// ... other options
},
(err, result, fields) => {
if (err instanceof Error) {
console.log(err);
return;
}
console.log(result);
console.log(fields);
}
);
- 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[])
- promise.js
- callback.js
try {
const sql = 'INSERT INTO `users`(`name`, `age`) VALUES (?, ?), (?,?)';
const values = ['Josh', 19, 'Page', 45];
const [result, fields] = await connection.execute(
{
sql,
// ... other options
},
values
);
console.log(result);
console.log(fields);
} catch (err) {
console.log(err);
}
const sql = 'INSERT INTO `users`(`name`, `age`) VALUES (?, ?), (?,?)';
const values = ['Josh', 19, 'Page', 45];
connection.execute(
{
sql,
// ... other options
},
values,
(err, result, fields) => {
if (err instanceof Error) {
console.log(err);
return;
}
console.log(result);
console.log(fields);
}
);
- 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.