JZTXT

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

发布时间 2023-09-12 21:52:59作者: 陆陆无为而治者

查询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;