C++ MySQL Connector Multiple Databases

Question

I connect and transform some table data in db1. Further down I want to send that data to a table in a different database db2.

MYSQL* conn;
conn = mysql_init(0);
conn = mysql_real_connect(conn, "localhost", "root", "password", "db1", 3306, NULL, 0);

if (conn) {
        ...
        // transform data

        // Connect to "db2" and insert data into table

Do I need to use CLIENT_MULTI_RESULTS when establishing a connection? Or create a new conn?

Is db2 in the same mysql instance as db1?

Shadow
– Shadow

2020-03-24 09:58:38 +00:00
Commented Mar 24, 2020 at 9:58 — Shadow
– Shadow, Commented Mar 24, 2020 at 9:58

jayjey · Accepted Answer · 2020-03-24 11:28:21Z

-1

I figured it out. Just creating another variable and calling it later worked.

MYSQL* conn;
MYSQL* conn2;
conn = mysql_init(0);
conn2 = mysql_init(0);
conn = mysql_real_connect(conn, "localhost", "root", "password", "db1", 3306, NULL, 0);
conn2 = mysql_real_connect(conn2, "localhost", "root", "password", "db2", 3306, NULL, 0);

...

if(conn)
{ 
    puts("CONN CONNECTION SUCCESSFUL")
    ...        
    if(conn2)
    {
        puts("CONN2 CONNECTION SUCCESSFUL")
        ...

answered Mar 24, 2020 at 11:28

jayjey

1279 bronze badges

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

3 Comments

Shadow Over a year ago

If the two databases are in single mysql instance, then you only need 1 connection. Use dbnane.tablename method to access a table in the other database.

jayjey Over a year ago

Could you provide an example please?

Shadow Over a year ago

stackoverflow.com/questions/22912167/…

Collectives™ on Stack Overflow

C++ MySQL Connector Multiple Databases

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related