通过sql server 连接mysql

 

、建立数据源

2、

 

 

 

 --查询
SELECT * FROM OPENQUERY(MYSQL_DBLINK, 'select * from tableName where id=''1''')

--修改
UPDATE OPENQUERY(MYSQL_DBLINK, 'select * from tableName where id=''1''') set cname='测试'
--or
UPDATE OPENQUERY(MYSQL_DBLINK, 'select * from tableName ') set cname='测试' where id=1

--添加
INSERT INTO OPENQUERY(MYSQL_DBLINK, 'select * from tableName where 1=0')values ('xx','xx','xx');  

--删除
DELETE  FROM OPENQUERY(MYSQL_DBLINK, 'select * from tableName where id=''1''')



参考地址：
http://www.cnblogs.com/licin/p/6244169.html
http://www.cnblogs.com/zerocc/p/4185627.html
https://yq.aliyun.com/wenzhang/show_68211