* * *

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

Zvoni

  • Jr. Member
  • **
  • Posts: 57
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 »
People call me crazy because i'm jumping out of perfectly fine airplanes.
I say you're crazy not to!
--------------------------------------------------------------------------------------------------
For health reasons i try to avoid reading unformatted Code

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus