mysql\_stmt\_bind\_param(3) MariaDB Connector/C mysql\_stmt\_bind\_param(3)

## [Name](#Name)

mysql\_stmt\_bind\_param - Binds parameter to a prepared statement

## [Synopsis](#Synopsis)

```
#include <mysql.h>
my_bool mysql_stmt_bind_param(MYSQL_STMT * stmt,


                              MYSQL_BIND * bind);
    
```

## [Description](#Description)

Binds variables for parameter markers in the prepared statement that was passed to [**mysql\_stmt\_prepare(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_prepare.3). Returns zero on success, non-zero on failure.

## [Parameters](#Parameters)

•

stmt - a statement handle, which was previously allocated by [**mysql\_stmt\_init(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_init.3).

•

bind - an array of MYSQL\_BIND structures. The size of this array must be equal to the number of parameters.

## [Notes](#Notes)

•

The number of parameters can be obtained by [**mysql\_stmt\_param\_count(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_param_count.3).

•

If the number of parameters is unknown, for example when using [**mariadb\_stmt\_execute\_direct(3)**](/man/enterprise-packages/mariadb-11.4/mariadb_stmt_execute_direct.3), the number of parameters have to be specified with the [**mysql\_stmt\_attr\_set(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_attr_set.3) function.

## [See Also](#See_Also)

•

[**mariadb\_stmt\_execute\_direct(3)**](/man/enterprise-packages/mariadb-11.4/mariadb_stmt_execute_direct.3)

•

[**mysql\_stmt\_prepare(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_prepare.3)

•

[**mysql\_stmt\_bind\_result(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_bind_result.3)

•

[**mysql\_stmt\_execute(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_execute.3)

•

[**mysql\_stmt\_param\_count(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_param_count.3)

•

[**mysql\_stmt\_send\_long\_data(3)**](/man/enterprise-packages/mariadb-11.4/mysql_stmt_send_long_data.3)

Version 3.4

---

Document: mysql_stmt_bind_param(3) from mariadb-11.4 11.4.13-r4 (Chainguard OS)
Source: https://github.com/MariaDB/server.git