Which command in SQL is used to open an existing database?
Answers
Answered by
5
heya friend
mysql>show databases;
[this command will show u the list of databases available to u]
+----------------------------+
| Database |
+----------------------------+
| information_schema |
| Students |
| TUTORIALS |
| mysql |
| testing |
+--------------------------- +
mysql>use Students;
[this statement selects the database Students]
then its will show like
Database changed
hope this helps!!!!!!!!
mysql>show databases;
[this command will show u the list of databases available to u]
+----------------------------+
| Database |
+----------------------------+
| information_schema |
| Students |
| TUTORIALS |
| mysql |
| testing |
+--------------------------- +
mysql>use Students;
[this statement selects the database Students]
then its will show like
Database changed
hope this helps!!!!!!!!
Similar questions