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
信息
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
信息
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
信息
The connection used for the query (execute) can be obtained through the createConnection, createPool or createPoolCluster methods.