mysql.binds
mysql.binds
Function
Append multiple lines of batch binding parameters.
Syntax
mysql(dsn).query(sql).binds(rows)
Parameters
| Parameters | Type | Required | Default value | Description |
|---|---|---|---|---|
| rows | Array | Yes | None | A two-dimensional array; each row is a set of bound values. |
Return value
| Type | Description |
|---|---|
| Mysql | Returns the new MySQL query builder. |
Example
rows = [['A', 18], ['B', 20]] db = mysql('mysql://user:pass@127.0.0.1/test') result = db.query('insert into user(name, age) values (?, ?)').binds(rows).sql() // Output: insert into user(name, age) values ('A', 18), ('B', 20) /* binds: 2 rows, batch: 0, workers: 1 */ print result
Notes
- binds will report an error when there are missing parameters or the parameters are not two-dimensional arrays.
- all() and one() do not support binds.