tencent cloud

Database.exec
Download PDF
Last updated: 2025-03-11 20:05:05
Database.exec
Last updated: 2025-03-11 20:05:05
Download PDF
Database.exec is used to execute queries without returning database data.
exec(query: string, ...args: any[]): Result

Parameters

Parameter
Type
Description
query
string
Query Statement
...args
any[ ]
Placeholder parameter used for querying.

Return

Type
Description
Result
Query the return results.

Samples

Use exec to execute a database query:
import sql from 'pts/sql';

// Create a database instance using new.
const db = new sql.Database(sql.MySQL, "user:passwd@tcp(ip:port)/database")

export default function () {
  let result = db.exec("UPDATE user SET age=? WHERE name='zhangsan'", Math.floor(Math.random() * 100));
  console.log(JSON.stringify(result)); // {"lastInsertId":0,"rowsAffected":1}
}

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback