I'm trying to update a table in mysql from SQL SERVER:
UPDATE OPENQUERY(SRVLINK,'Select COLA, COLB, COLC from rtable
WHERE id = 157') set COLA = 2 ,
COLB= 'text', COLC = 'test'
id is the pK from the remote table (rtable)
I get this error:
OLE DB provider "MSDASQL" for linked server "SRVLINK" returned message "Key column information is insufficient or incorrect. Too many rows were affected by update.".
Basically I don't even need to select those columns, just update them by the index, is there a better way to achieve this ?
(writing a direct update query didn't work with openquery for some reason)