If we have to choose data from MYSQL then we will use a keyword ‘USE’ for this purpose. The basic structure is given below;
In case, we have to make connection to database named as ‘Record’. Then the process will be like this;
It is possible to get admittance to many tables from different database. For this purpose, we have to mention the name of database and the name of that table. In case, the database is in current use then it is not necessary to give the name of that database.
For instance, if we have to open the table “Lesson_111” from our database”Record” and table”Teachers” from our database “Staff”, then the syntax will be like this;
FROM Lesson_111, Staff.Teachers