

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the synonym statement of SHOW DATABASES with the help of which we can see the list of MySQL databases?
As we know that with the help of SHOW DATABASES statement we can see the list of MySQL databases. Similarly, we can use SHOW SCHEMAS as the synonym of SHOW DATABASES to get the list of databases.
Example
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | gaurav | | mysql | | performance_schema | | query | | query1 | | sys | | tutorials | +--------------------+ 8 rows in set (0.07 sec) mysql> SHOW SCHEMAS; +--------------------+ | Database | +--------------------+ | information_schema | | gaurav | | mysql | | performance_schema | | query | | query1 | | sys | | tutorials | +--------------------+ 8 rows in set (0.00 sec)
- Related Questions & Answers
- Which MySQL query can be used with the help of which we can see the list of MySQL databases?
- How can we display a list of currently existing MySQL databases on the server?
- Return list of databases in MySQL?
- What is the BSON query for the command 'show dbs' (list of databases) in MongoDB?
- What is the way to check the size of all the MySQL databases?
- How can we check the default character sets of all the MySQL databases we have on the server?
- What is the purpose of using MySQL CHAR_LENGTH() function? Which function is the synonym of it?
- Explain the importance of centralized databases
- How can we see MySQL temporary tables in the list of tables?
- Get a list of MySQL databases and version?
- How can we get the list of MySQL server-side help categories?
- How can we filter data with the help of MySQL subquery?
- Types of databases
- How to get the list of all databases using JDBC?
- How to get the list of all the MongoDB databases using java?
Advertisements