如何在PHP中使用sql连接在两个数据库上执行查询 [英] how to use sql connection in PHP to execute a query on two databases

问题描述

我如何运行一个查询，该查询将来自mssql_query或php中mysql_query的两个不同数据库的两个表联接在一起 例如

how can i run a query that joins two tables from TWO different Databases in mssql_query or mysql_query in php for example

$conn=mssql_connect($ip,$username,$password);
mssql_select_db("DB1",$conn);
$q="select A.name,B.ID from DB1.dbo.T1 A, DB2.dbo.T2 B where A.ID=B.ID";
$res=mssql_query($q);

如何运行此类查询?

推荐答案

只需在表名前面加上数据库名称即可.

Just prefix the tablenames with the database name, as you are already doing.

用于连接到mySQL的用户登录名必须有权访问两个数据库.没有这个，这是不可能的.

The user login that you are using to connect to mySQL needs to have access to both databases. Without this, it is impossible.

这篇关于如何在PHP中使用sql连接在两个数据库上执行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！