My sql query for select all databases except system databases
I have made asp.net application which communicate MySQL using c# as code behind.I need MySQL query or custom function which gives me list of databases except system databases name.
You must Sign In to post a response.
Category: ASP.NET
I need MySQL query or custom function which gives me list of databases except system databases name.
#769576
Hi
You can use this command for list all databases in MySQL Database
Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com
'Not by might nor by power, but by my Spirit,' says the LORD Almighty.
You can use this command for list all databases in MySQL Database
SHOW DATABASES;
SELECT schema_name
FROM information_schema.schemata;
Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com
'Not by might nor by power, but by my Spirit,' says the LORD Almighty.
#769589
SHOW DATABASES;
SELECT schema_name
FROM information_schema.schemata;
above both query gives following output
'information_schema'
'test'
'mysql'
'performance_schema'
'sys'
i want only test using any query or any custom function that i can use in code behind in c#.
Thanks for replying on my post.
SELECT schema_name
FROM information_schema.schemata;
above both query gives following output
'information_schema'
'test'
'mysql'
'performance_schema'
'sys'
i want only test using any query or any custom function that i can use in code behind in c#.
Thanks for replying on my post.
Return to Return to Discussion Forum