# mysql.binds

## Function

Append multiple lines of batch binding parameters.

## Syntax

```bt
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

```bt
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.