tencent cloud

All product documents
Tencent Cloud Observability Platform
DocumentationTencent Cloud Observability PlatformPerformance Testing ServiceJavaScript API Listpts/sqlDatabaseDatabase.query
Database.query
Download PDF
Last updated: 2025-03-11 20:05:05
Database.query
Last updated: 2025-03-11 20:05:05
Download PDF
Database.query is used to execute queries and return database data. 
query(query: string, ...args: any[]): Record<string, any>[]

Parameters

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

Return

Type
Description
Record<string, any>[]
Query the returned results, containing database data.

Samples

Use query 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 rows = db.query("SELECT * FROM user");
  
  // [{"id":1,"name":"zhangsan","age":23},{"id":2,"name":"lisi","age":2}]
  console.log(JSON.stringify(rows)); 
}

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