How to update row in SQL server using linked MySql server

Question

I created linked server between sql server and mysql.It will work fine for me. My question is when insert row in mysql table that time i want to update row in sql server table,

Like in mysql table name 'abc' when in this table new row insert that time in ms sql server table name is xyz and in this field name status by default true and when new row insert in the abc table that time in xyz table field name status will automatically update and status will change to false.

My linked server name is MYLINK and it will work fine for me , I want to create trigger which update row in sql server,and how to create trigger for update row in the ms sql server.

The question probably interesting, but I think you will have to edit it in order to make things much more clear if you want accurate answers. — Sylvain Leroux
– Sylvain Leroux, Commented Aug 8, 2013 at 9:02

Sudharsun · Accepted Answer · 2013-09-20 05:43:27Z

1

ALTER TRIGGER [TriggerLocalServerTable]
   ON  dbo.[LocalServerTable]
    FOR INSERT
AS 

DECLARE @A varchar(4)
DECLARE @B varchar(4)
DECLARE @id int

BEGIN
 SELECT
 @A = A,
 @B = B,
 @id = id
 FROM inserted

 UPDATE  [LinkedServer].[Database].[dbo].[Table]
 SET A = @A, B = @B
 WHERE id = @id      
END

answered Sep 20, 2013 at 5:43

Sudharsun

7616 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vijay · Accepted Answer · 2014-02-26 03:57:59Z

1

mysql cannot trigger anything else but mssql. But you can use SQL Agent to schedule a task, executed on sql server to select data from the linked mysql

edited Feb 26, 2014 at 3:57

Vijay

8,47111 gold badges47 silver badges70 bronze badges

answered Aug 13, 2013 at 19:23

jean-hugues

313 bronze badges

Collectives™ on Stack Overflow

How to update row in SQL server using linked MySql server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related