eg:
SELECT
city.ID,
city.`Name`,
city.CountryCode,
city.District,
city.Population,
adv_site.ADD_DATE
FROM
city ,wulianb.adv_site
city库名,wulianb库名 ,adv_site表名
eg:
SELECT
city.ID,
city.`Name`,
city.CountryCode,
city.District,
city.Population,
adv_site.ADD_DATE
FROM
city ,wulianb.adv_site
city库名,wulianb库名 ,adv_site表名
转载于:https://www.cnblogs.com/leonlee/p/5387643.html