Hyaku_ Posted January 15, 2007 Share Posted January 15, 2007 Hi!For example have two databases db_1 and db_2.db_2 contains table TABLE_2 and if I have selected db_1, is there a query like:[code]SELECT * FROM TABLE_2 [FROM db_2][/code]?Thanks! Link to comment https://forums.phpfreaks.com/topic/34310-query-to-select-table-from-another-database/ Share on other sites More sharing options...
fenway Posted January 15, 2007 Share Posted January 15, 2007 Assuming you can connect to both DBs with the same user credentials, you can simply prefix the table name with the database name. Link to comment https://forums.phpfreaks.com/topic/34310-query-to-select-table-from-another-database/#findComment-161470 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.