Entry

Database: Language: SQL: MySql: Database: Operation: View: How to view all created databases?

Apr 4th, 2005 09:26
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 04 April 2005 - 11:37 pm ----------------------

Database: Language: SQL: MySql: Database: Operation: View: How to view 
all created databases?

---

Use the command

 show databases

e.g.

--- cut here: begin --------------------------------------------------

mysql> show databases;

+-----------------+
| Database        |
+-----------------+
| database1       |
| databasemytest  |
| databasemytest1 |
| mysql           |
| test            |
| test1           |
| test2           |
+-----------------+

7 rows in set (0.01 sec)

--- cut here: end ----------------------------------------------------

---
---

Internet: see also:

---

Database: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------