tencent cloud

All product documents
Tencent Cloud Observability Platform
DocumentationTencent Cloud Observability PlatformPerformance Testing ServiceJavaScript API Listpts/sqlDatabaseDatabase.exec
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

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon