MySQL Selecting Database
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 calledTUTORIALS:
[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 names, table names, table fields name are case sensitive. So you would have to use proper 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:
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 bymysql_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>
ليست هناك تعليقات:
إرسال تعليق