You must Sign In to post a response.
  • Category: ASP.NET

    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.
  • #769576
    Hi

    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.


  • Sign In to post your comments