How to assign mysql result to variable (in C)

Question

I can't assign the result of query to variable (the program is written in C). Here is what I do

char buffer[100];

while ((row = mysql_fetch_row(res)) != NULL) {
   buffer = row[0];
}

A get this error during compile process

error: incompatible types in assignment

What is wrong here ?

Preet Sangha · Accepted Answer · 2011-12-16 10:25:16Z

3

Assuming it's a string? C doesn't have strings it has arrays of characters. So you have copy the characters from one array to another.

so use a copy function like

strncpy(buffer, row[0], 100);

answered Dec 16, 2011 at 10:11

Preet Sangha

65.7k20 gold badges152 silver badges227 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Also, be sure that a length of 100 is enough.

A note mainly to the question asker: mysql_fetch_lengths can be used to know how long (in bytes) each field is.