Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
mysql_select_db(3)	      MariaDB Connector/C	    mysql_select_db(3)

   Name
       mysql_select_db - selects a database as default

   Synopsis
	      #include <mysql.h>

	      int mysql_select_db(MYSQL	* mysql,
				  const	char * db);

   Description
       Selects	a  database  as	default.  Returns zero on success, non-zero on
       failure

   Parameters
        mysql is a connection identifier, which was previously	 allocated  by
	 mysql_init(3) and connected by	mysql_real_connect(3).

        db - the default database name

   Notes
        To  retrieve  the name	of the default database	either execute the SQL
	 command SELECT	DATABASE() or retrieve the value  via  mariadb_get_in-
	 fov(3)	API function.

        The  default  database	 can  also  be	set  by	 the  db  parameter in
	 mysql_real_connect(3).

   Examples
   SQL
	      #	switch to default database test
	      USE test;
	      #	check default database
	      SELECT DATABASE();
	      +------------+
	      |	database() |
	      +------------+
	      |	test	   |
	      +------------+

   MariadDB Connector/C
	      static int set_default_db(MYSQL *mysql)
	      {
		int rc;
		char *default_db;

		/* change default database to test */
		rc= mysql_select_db(mysql, "test");
		if (rc)
		  return rc;  /* Error */

		/* get the default database */
		rc= mariadb_get_infov(mysql, MARIADB_CONNECTION_SCHEMA,	&default_db);
		if (rc)
		  return rc; /*	Error */

		if (strcmp("test", default_db) != NULL)
		{
		  printf("Wrong	default	database\n");
		  return 1;
		}
		printf("Default	database: %s", default_db);
		return 0;
	      }

   See also
       mysql_real_connect(3)

Version	3.4						    mysql_select_db(3)

Want to link to this manual page? Use this URL:
<
https://man.freebsd.org/cgi/man.cgi?query=mysql_select_db&sektion=3&manpath=FreeBSD+Ports+14.3.quarterly>

home | help