INST 327 Lecture Notes - Lecture 9: Cmd.Exe, Mysql
Document Summary
Once you get connected with the mysql server, it is required to select a database to work with. This is because there might be more than one database available with the mysql server. It is very simple to select a database from the mysql> prompt. You can use the sql command use to select a database. Here is an example to select a database called tutorials . Now, you have selected the tutorials database and all the subsequent operations will be performed on the tutorials database. Note all the database names, table names, table fields name are case sensitive. So you would have to use the proper names while giving any sql command. Php provides function mysql_select_db to select a database. Here is an example showing you how to select a database. Properly defining the fields in a table is important to the overall optimization of your database.