MySQL :: MySQL 8.4 C API Developer Guide :: 6.4.27 mysql_stmt_send_long_data() (original) (raw)

6.4.27 mysql_stmt_send_long_data()

bool
mysql_stmt_send_long_data(MYSQL_STMT *stmt,
                          unsigned int parameter_number,
                          const char *data,
                          unsigned long length)

Return Values

Zero for success. Nonzero if an error occurred.

Errors

• CR_INVALID_BUFFER_USE
  The parameter does not have a string or binary type.
• CR_INVALID_PARAMETER_NO
  Invalid parameter number.
• CR_COMMANDS_OUT_OF_SYNC
  Commands were executed in an improper order.
• CR_SERVER_GONE_ERROR
  The MySQL server has gone away.
• CR_OUT_OF_MEMORY
  Out of memory.
• CR_UNKNOWN_ERROR
  An unknown error occurred.

Example

The following example demonstrates how to send the data for aTEXT column in chunks. It inserts the data value 'MySQL - The most popular Open Source database' into thetext_column column. Themysql variable is assumed to be a valid connection handler.

#define INSERT_QUERY "INSERT INTO \
                      test_long_data(text_column) VALUES(?)"

MYSQL_BIND bind[1];
long       length;

stmt = mysql_stmt_init(mysql);
if (!stmt)
{
  fprintf(stderr, " mysql_stmt_init(), out of memory\n");
  exit(0);
}
if (mysql_stmt_prepare(stmt, INSERT_QUERY, strlen(INSERT_QUERY)))
{
  fprintf(stderr, "\n mysql_stmt_prepare(), INSERT failed");
  fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
  exit(0);
}
 memset(bind, 0, sizeof(bind));
 bind[0].buffer_type= MYSQL_TYPE_STRING;
 bind[0].length= &length;
 bind[0].is_null= 0;

/* Bind the buffers */
if (mysql_stmt_bind_named_param(stmt, bind, 1, NULL))
{
  fprintf(stderr, "\n param bind failed");
  fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
  exit(0);
}

 /* Supply data in chunks to server */
 if (mysql_stmt_send_long_data(stmt,0,"MySQL",5))
{
  fprintf(stderr, "\n send_long_data failed");
  fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
  exit(0);
}

 /* Supply the next piece of data */
 if (mysql_stmt_send_long_data(stmt,0,
           " - The most popular Open Source database",40))
{
  fprintf(stderr, "\n send_long_data failed");
  fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
  exit(0);
}

 /* Now, execute the query */
 if (mysql_stmt_execute(stmt))
{
  fprintf(stderr, "\n mysql_stmt_execute failed");
  fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
  exit(0);
}