{"id":423,"date":"2019-10-18T14:15:13","date_gmt":"2019-10-18T07:15:13","guid":{"rendered":"https:\/\/mariadbtutorial.com\/?page_id=423"},"modified":"2020-04-11T23:24:03","modified_gmt":"2020-04-11T16:24:03","slug":"mariadb-select-database","status":"publish","type":"page","link":"https:\/\/www.mariadbtutorial.com\/mariadb-basics\/mariadb-select-database\/","title":{"rendered":"Selecting a MariaDB Database"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to select a MariaDB database as the current database.<\/p>\n\n\n\n

Introduction to the use statement<\/h2>\n\n\n\n

If you connect to the MariaDB server<\/a> without explicitly specifying a particular database, you need to select a database as the current database to work with.<\/p>\n\n\n\n

To select a specific database, you issue the use<\/code> statement as follows:<\/p>\n\n\n

use<\/span> database_name;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, you specify the name of the database after the use<\/code> keyword.<\/p>\n\n\n\n
The use<\/code> statement instructs MariaDB to use the database_name<\/code> as the current database for the subsequent statements.<\/p>\n\n\n\n
If you issue a query without selecting a database, you will receive the following error:<\/p>\n\n\n
ERROR 1046 (3D000): No database selected\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Select a database using the MySQL command-line program<\/h2>\n\n\n\n
First, connect to the MariaDB server using the mysql client program:<\/p>\n\n\n
mysql -u root -p\nEnter password: ********\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
mysql> show<\/span> databases<\/span>;\n+--------------------+<\/span>\n| Database           |\n+--------------------+<\/span>\n| information_schema |\n| mysql              |\n| nation             |\n| performance_schema |\n| test               |\n+--------------------+<\/span>\n5 rows in set<\/span> (0.00<\/span> sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Third, select the nation<\/code> database by using the use<\/code> statement:<\/p>\n\n\n
mysql> use<\/span> nations;\nDatabase changed\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Starting from now, all the queries that you issue will execute in the context of the nation<\/code> database until the end of the session or another use<\/code> statement is issued.<\/p>\n\n\n\n
For example, you can use the show tables<\/code> statement to display all tables:<\/p>\n\n\n
mysql> show<\/span> tables<\/span>;\n+-------------------+<\/span>\n| Tables_in_nation  |\n+-------------------+<\/span>\n| continents        |\n| countries         |\n| country_languages |\n| country_stats     |\n| guests            |\n| languages         |\n| region_areas      |\n| regions           |\n| vips              |\n+-------------------+<\/span>\n9 rows in set<\/span> (0.00<\/span> sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
To find the current database, you can use the database()<\/code> function:<\/p>\n\n\n
mysql> select<\/span> database<\/span>();\n+------------+<\/span>\n| database() |\n+------------+<\/span>\n| nation     |\n+------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this tutorial, you have learned how to select a MariaDB database as the current database by using the use<\/code> statement<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t
Second, show all available databases in the server using the show databases<\/a><\/code> statement:<\/p>\n\n\n