mysql\_stmt\_send\_long\_data(3) MariaDB Connector/C mysql\_stmt\_send\_long\_data(3)

## [Name](#Name)

mysql\_stmt\_send\_long\_data - Sends data in chunks

## [Synopsis](#Synopsis)

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


                                  unsigned int,


                                  const char * data,


                                  unsigned long);
    
```

## [Description](#Description)

Allows sending parameter data to the server in pieces (or chunks), e.g. if the size of a blob exceeds the size of max\_allowed\_packet size. This function can be called multiple times to send the parts of a character or binary data value for a column, which must be one of the TEXT or BLOB datatypes.

## [Parameter](#Parameter)

•

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

•

param\_no - indicates which parameter to associate the data with. Parameters are numbered beginning with 0.

•

data - a buffer containing the data to send.

•

long - size of the data buffer.

## [Return value](#Return_value)

Returns zero on success, nonzero if an error occurred.

## [Notes](#Notes)

•

mysql\_stmt\_send\_long\_data() must be called before [**mysql\_stmt\_execute(3)**](/man/enterprise-packages/mariadb-12.3/mysql_stmt_execute.3).

•

bound variables for this column will be ignored when calling [**mysql\_stmt\_execute(3)**](/man/enterprise-packages/mariadb-12.3/mysql_stmt_execute.3).

## [See also](#See_also)

•

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

Version 3.4

---

Document: mysql_stmt_send_long_data(3) from mariadb-12.3 12.3.3-r5 (Chainguard OS)
Source: https://github.com/MariaDB/server.git