python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - mysql-connector-c

C program cannot get result value from MySQL procedure

I am practicing with getting a value back from a MySQL stored procedure So I first created the following procedure USE testdb; DROP PROCEDURE IF EXISTS `testdb`.`get_return_value_test`; DELIMITER $$ ...
test-img

Ctrl_halt

mysql

stored-procedures

mariadb

mariadb-connector-c

mysql-connector-c

Votes: 0

Answers: 1

Latest Answer

101 is defined as the value for MYSQL_DATA_TRUNCATED in mysql.h https://dev.mysql.com/doc/c-api/8.0/en/mysql-stmt-fetch.html says: MYSQL_DATA_TRUNCATED is returned when truncation reporting is enable...
test-img

Bill Karwin

mysql c api interface: how to make bulk fetch : array of structures

In ProC oracle, to get "bulk rows from a table(s) in one shot" ( without any for loop iteration in code) : we use Embedded sql calls to declare cursor to define a sql select statement . Then...
test-img

shibendra chakraborty

arrays

fetch

mysql-connector

bulk

mysql-connector-c

Votes: 0

Answers: 1

Latest Answer

While the C API statements are for fetching a row, they do not always require a round trip to the server to retrieve the data. The SQL statement results are retrieved into the net-buffer, which will r...
test-img

danblack

Posts

Questions

Blogs

Jobs