Database.query
Last updated: 2025-03-10 17:15:12
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