Selecting MySQL Database

« Previous Chapter Next Chapter »

Once you get connection with MySQL server,it is required to select a particular database to work with. This is because there may be more than one database available with MySQL Server.

Selecting MySQL Database from Command Prompt:

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

Example:

Here is an example to select database called TUTORIALS:

Example

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

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

NOTE: all the database name, table names, table fields name are case sensitive. So you would have to use prpoer names while giving any SQL command.

Selecting 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:

Example

bool mysql_select_db( db_name, connection );


Parameter Description
db_name Required - MySQL Database name to be selected
connection Optional - if not specified then last opened connection by mysql_connect will be used.

Example:

Here is the example showing you how to select a database.

Example

<html>
<head>
<title>Selecting MySQL Database</title>
</head>
<body>
<?php
$dbhost = 'localhost:3036';
$dbuser = 'guest';
$dbpass = 'guestpass';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db( 'TUTORIALS' );
mysql_close($conn);
?>
</body>
</html>


« Previous Chapter Next Chapter »
Have Any Suggestion? We Are Waiting To Hear from YOU!

Your Query was successfully sent!