0
const sqlu = 'update tempcsvuploaddss t, temp2 t2 
              set t.matchartist = t2.artist, 
                  t.matchtrack=t2.track  
              where  t2.IsFound = "Y"  
              and t.matchartist is null 
              and t.matchtrack is null ';
Query(sqlu);

Now result looks like this:


1

only one record is updated in all rows how to i can update all records

eshirvana
  • 23,227
  • 3
  • 22
  • 38
fawad ahmed
  • 1
  • 1
  • 3
  • I don't see that you have joined both tables. So it's not a surprise that you get more or less a random result. – cboden Dec 13 '20 at 18:45
  • 1
    @fawad which dbms are you using? – eshirvana Dec 13 '20 at 19:25
  • Does this answer your question? [MySQL, update multiple tables with one query](https://stackoverflow.com/questions/4361774/mysql-update-multiple-tables-with-one-query) – astentx Dec 13 '20 at 19:46
  • Screenshot of results tells exactly nothing without input data. Also do not use screenshot of data when it is not about visualization or data cannot be grabbed from UI without loss of information. Use text in tabular format. – astentx Dec 13 '20 at 19:48

0 Answers0