【SQL Server】通过SQL Server操作MySQL（下）—— 操作MySQL

查询MySQL 语句

select * from openquery(TestMySQL,'select * from test.TestTable');

向MySQL表中插入数据

insert into openquery(TestMySQL,'select * from test.TestTable')

select 1,'TestName';

删除MySQL 表中的数据

delete from openquery(TestMySQL,'select * from test.TestTable');

修改MySQL表中的数据

update openquery(TestMySQL,'select * from test.TestTable')
set TestName='ABCDE' where TestID=1;