Copyright © tutorialspoint.com
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.
This is very simple to select a particular database from mysql> prompt. You can use SQL command use to select a particular database.
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.
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.
PHP provides function mysql_select_db to select a database.It returns TRUE on success or FALSE on failure.
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. |
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> |
Copyright © tutorialspoint.com