Setting the active database using mysql C API

[guest_user]

how do I set the active database after logging in:

mysql_real_connect( conn, "localhost", "username", "password", NULL, 0, NULL, 0 );
mysql_query( conn, "create database test" );

after this, now that the database is created, how can I set the active database to be test?

[slavik]

how do I set the active database after logging in:

mysql_real_connect( conn, "localhost", "username", "password", NULL, 0, NULL, 0 );
mysql_query( conn, "create database test" );

after this, now that the database is created, how can I set the active database to be test?
Answer: http://dev.mysql.com/doc/refman/5.0/en/mysql-change-user.html

[MadCow108]

I guess select_db is what op wants:
http://dev.mysql.com/doc/refman/5.0/en/mysql-select-db.html

[guest_user]

I guess select_db is what op wants:
http://dev.mysql.com/doc/refman/5.0/en/mysql-select-db.html

yup but my concern is whether is it deprecated?

[slavik]

I guess select_db is what op wants:
http://dev.mysql.com/doc/refman/5.0/en/mysql-select-db.html
I fail at reading :(

[MadCow108]

yup but my concern is whether is it deprecated?

I see no indication that it is deprecated.

mysql_create_db is deprecated but not mysql_select_db
http://dev.mysql.com/doc/refman/5.5/en/mysql-create-db.html

you can also use mysql_query with a "use test" to select the database

[guest_user]

thank you