Learn How to Select and Use Existing Database using SQL
Learn how to Select and use existing database in SQL. After creating the databases successfully, The user must select the database before creating new tables or return the data rows from existing tables. Selecting the desired database is really important because multiple databases may contain, similar table names. And its difficult for SQL statement to figure out the exact database and its table. The database is selected by using USE statement.
Here is the SQL statement to select the database. "USE databasename;"
lets display all the existing databases using SQL statement, "SHOW DATABASES;". The system displays all the available database.
Now, select the company database using SQL statement, "USE company;"
Check out the whole playlist of SQL Tutorials or Individual video from the following links,
SQL Tutorial for Beginners. Introduction to SQL Basics
• SQL Tutorial for Beginners. Introduct...
1.Learn What is SQL? Introduction to SQL
• Learn What is SQL? Introduction to SQL
2.Learn How to Install MySQL Database Server on Windows Operating System
• Learn How to Install MySQL Database S...
3.Learn What is Database? How to Create and Show Databases using SQL
• Learn What is Database? How to Create...
4.Learn How to Select and Use Existing Database using SQL
• Learn How to Select and Use Existing ...
5.Learn How to Delete or Remove Database using SQL
• Learn How to Delete or Remove Databas...
6.Learn What is Database Table? How to Create a Database Table using SQL?
• Learn What is Database Table? How to ...
7.Learn How to Modify or Update Database Table using SQL
• Learn How to Modify or Update Databas...
8.Learn How to Delete or Remove Database Table using SQL
• Learn How to Delete or Remove Databas...
9.Learn How to Add Data Rows in a Table using SQL
• Learn How to Add Data Rows in a Table...
10.Learn How to Use INSERT INTO SELECT Statement in SQL
• Learn How to Use INSERT INTO SELECT S...
11.Learn How to Update Data Rows using Update Statement in SQL
• Learn How to Update Data Rows using U...
12.Learn How to Delete Data Rows using Delete Statement in SQL
• Learn How to Delete Data Rows using D...
Subscribe to my channel: / @pntutorialsbypradnyankurnikam