
2.使用dbname.tablename的方式来写from,或者join(前提是你用于连接MYSQL的帐号必须同时可以访问这两个库)
例如:dba,dbb
select * from dba.table1 as t1
join dbb.table1 as t2 on t1.id = t2.id
select a.XXX, b.XXX, c.XXX from tb1 as a inner join tb2 as b on a.fid=b.freplyid inner join tb3 as c on a.fimgid=c.fcontentid欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)