Search code examples
mysqlphpmyadminmultiple-databases

How to access content in another database from PHPMyAdmin

I have two databases, one that is for my web-app and the other is for my android app. I wish to occasionally allow the Android app to query and insert into the table in the database for the web-app, but do not know how to do so.

Is it simply an SQL query but with the specifying parameter for which database it is ie.

select * from webAppsDB.WebAppTable...?

How is this managed?

Solution

  • You could use USE statement first, like

     USE webAppsDB;

 SELECT * FROM WebAppTable