CODEWITHSUNDEEP
mysqlsql-server
pardhu
pardhu

Reputation: 81

i need Update Query from Mssql to Mysql in LINKED Server

Actually i need to connect Mssql to Mysql , Fortunately i did with MSSQL 2008 R2 linked server i made connection for Mysql

Now i want to write some queries for update at a time in both databases when i am trying this query 

update products set Stock=A.Stock from
  (Select * FROM OPENQUERY(MYSQL,'Select * From products where Id=8')) A
  inner join products B on b.Id=a.Id

the rows of MSSQL is updated from MYSQL

i need to update MSSQL to MYSQL also

please help me out ,i am working since last 4 days

Upvotes: 2

Views: 9615

Answers (1)

pardhu
pardhu

Reputation: 81

MYSQL TO MSSQL UPDATION: 

update products set Stock=A.Stock from
(Select * FROM OPENQUERY(MYSQL,'Select * From products')) A
inner join products B on b.Id=a.Id



UPDATE employee
SET LastName = ( Select FirstName from employee where FirstName = (SELECT * FROM
OPENQUERY(MYSQL, 'Select FirstName from employee where IndividualId=3')))

MSSQL TO MYSQL UPDATION:

UPDATE OPENQUERY (database, 'SELECT Stock FROM wings.products WHERE id =1') 
SET Stock=999;

Upvotes: 6

Related Questions