Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Compare and Update

MrMix's profile image MrMix posted 2 weeks ago in General Permalink

Hello, I can't figure out how write a query where I can update some lines after comparing two columns.

I have a db named 'nolim' with two tables 'product' and 'income'.

The table 'product' has several columns among which 'path' and 'rate'.

The table 'income' has several columns among which 'line' and 'quote'.

Now here what I'd like to do:

if the field (txt) in column 'line' of 'income' table is the same of 'path' in 'product' table than the value into 'quote' should be copied into 'rate'

See attached txt file as an example

Thank you for your help.

MM

1 attachment(s):

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.