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:
[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.
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:
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.
<html>
<head>
<title>Selecting MySQL Database</title>
</head>
<body>
<?php
$dbhost = 'localhost:3036';
$dbuser = 'guest';
$dbpass = 'guest123';
$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>
|
