Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
my target database don't support update primary key
how can I set to filter primary key column.
eg:
the table has three columns: col1,col2,col3,the column col1 is primary key
when one update sql is running,replcate generate update sql like this
update test set col1=?,col2=?,col3=? where col1=?;
but I want to the sql like this:
update test set col2=?,col3=? where col1=?;
How should I set the table selectings
Hi @XiaoyongLin ,
Can you please describe the requirement in detail?
The tabular format will be eaiser to understand.