I have to update all the rows of a Column in a table. Here is my query
Try this: 

UPDATE tracks t 
INNER JOIN top100 t1 ON t.track_title = t1.track_title 
LEFT JOIN People p ON t1.artist = p.People_name 
SET t.People_id_Reference = p.People_id 
WHERE t.People_id_Reference IS NULL;