Recent

Author Topic: MySQL5.7 Show only User-created Database(s)  (Read 1400 times)

Zvoni

  • Hero Member
  • *****
  • Posts: 2319
MySQL5.7 Show only User-created Database(s)
« on: April 27, 2018, 08:51:42 pm »
Hi Folks,

quick question: Is there any way to list all Databases in MySQL only showing the user-created databases, but not the system ones (mysql, sys, information_schema, performance_schema)?

I know of "show databases", but that one shows all

thx
Zvoni

EDIT: I've created a View excluding those Databasenames.
Solved
« Last Edit: April 27, 2018, 11:30:16 pm by Zvoni »
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

 

TinyPortal © 2005-2018