


PHP uses mysqli_select_db function to select the database on which queries are to be performed. Selecting a MySQL Database Using PHP Script So you would have to use the proper names while giving any SQL command. NOTE − All the database names, table names, table fields name are case sensitive. Now, you have selected the TUTORIALS database and all the subsequent operations will be performed on the TUTORIALS database.

Here is an example to select a database called TUTORIALS mysql -u root -p You can use the SQL command use to select a database. It is very simple to select a database from the mysql> prompt. Selecting MySQL Database from the Command Prompt This is because there might be more than one database available with the MySQL Server. Once you get connected with the MySQL server, it is required to select a database to work with.
