Billing Overview
Pay-as-You-Go (postpaid)
Purchasing Channels
Payment Overdue
Refund Instructions
new (driverName: string, dataSourceName: string): Database
Parameter | Type | Description |
driverName | string | The driver name, currently supports 'mysql'. |
dataSourceName | string | Data source. |
Methodology | Return Type | Description |
Execute queries without returning row data. | ||
Record<string, any>[] | Execute queries and return row results, typically a SELECT. |
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}let rows = db.query("SELECT * FROM user");console.log(JSON.stringify(rows)); // [{"id":1,"name":"zhangsan","age":23},{"id":2,"name":"lisi","age":2}]}
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback