$sql = "SELECT c.id as c_id, w.id as w_id, c.city as cms_city, FROM `cms_hotel` as c and c.country_code=w.country_code
join states as s on (w.state_code= s.
我想将数据从MySQL数据库传输到MySQL数据库。因此,我向MySQL添加了一个链接服务器,以便可以使用Openquery将数据插入到MySQL数据库中。我希望优化数据传输的性能,并找到了在MySQL中提高数据加载性能的指导方针。SELECT * from openquery(MYSQL,'SET autocommit=