Inserting into MySQL table using a variable

Question

I have long known that one could fetch results from a mysql table and print it as :

(MySQL C API)

MYSQL_RES *result = mysql_store_result(con);

if (result == NULL)    
{    
  finish_with_error(con);    
}

int num_fields = mysql_num_fields(result);        
MYSQL_ROW row;        
while ((row = mysql_fetch_row(result)))    
{     
   printf("%s ", row[i] ? row[i] : "NULL");    
}

Now suppose I have to copy a database into another, can I do the other way round i.e can I somehow use the row variable to insert into the new database.

If I could do this copying a database would be so easy.

By copying a database I mean I have to create a database that is exactly the same as the original one, with all its data and attributes being the same.

horsefeathers · Accepted Answer · 2015-03-18 11:21:33Z

1

I think prepared statements/PDO should work for what you're looking for. Without knowing what your table schema looks like, it's a bit hard to tell you what the statement would look like, but here's some information for the C API.

http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statements.html http://dev.mysql.com/doc/refman/5.0/en/c-api-prepared-statement-data-structures.html http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-prepared-statements.html

answered Mar 18, 2015 at 11:21

horsefeathers

1165 bronze badges

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

5 Comments

Novak007 Over a year ago

i intend to transfer mysql database from one client to another, through sockets and mysql c api.

Novak007 Over a year ago

please give a few more hints.

horsefeathers Over a year ago

So you are looking for a function to copy the database, or you have the new database and you are looking to load the data into it?

Novak007 Over a year ago

i have a database on my client 1, i have to create a copy of that database on client 2 all connected through tcp sockets. i must do it through mysql c api.

horsefeathers Over a year ago

Hmm.. If you have to copy the database as well as the data, then I don't think prepared statements are your best option actually. They're good for queries such as simple inserts, but for copying an entire database I think you'll want something heftier.

Collectives™ on Stack Overflow

Inserting into MySQL table using a variable

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related