Select database query in MySQL

It is very simple to select a database from the mysql> prompt. You can use the SQL command use to select a database.

Example

Here is an example to select a database called TUTORIALS −

[root@host]# mysql -u root -p Enter password:****** mysql> use TUTORIALS; Database changed mysql>

Now, you have selected the TUTORIALS database and all the subsequent operations will be performed on the TUTORIALS database.

NOTE − All the database names, table names, table fields name are case sensitive. So you would have to use the proper names while giving any SQL command.

Selecting a MySQL Database Using PHP Script

PHP provides function mysql_select_db to select a database. It returns TRUE on success or FALSE on failure.

Syntax

bool mysql_select_db( db_name, connection );

• Oracle database query tool
• Free database query tool
• sql database query tool