List Database with Java or PHP

Asked

Viewed 58 times

-2

I wonder if there is any way for an application to show all databases of a connection?

I currently use the command: 

select
     *
from
     information_schema.TABLES;
php java sql

  • It is not only run this query by the application?

  • database or tables?

  • 2

    if it is all databases is SHOW DATABASES (PHP/MYSQL) (https://dev.mysql.com/doc/refman/5.7/en/show-databases.html)

1 answer

1

just use the SHOW DATABASES at least with me it worked like this, using PHP and mysql

Browser other questions tagged php java sql

You are not signed in. Login or sign up in order to post.