mysql: populate column with autoincrement values

 

 

SET @my_increment := 0;
UPDATE linkedin_companies_to_analyze
SET id = @my_increment := @my_increment + 1
ORDER BY date_created;

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *