I have a mySQL DB table in a website. It has few thousand rows of data. I just added a column and need to add data to this column for row_id 1500 to 5000. I am thinking of doing this -
UPDATE `TableName` SET `Col_New` = 'abc' WHERE `id` = '1500'
and repeat this until -
UPDATE `TableName` SET `Col_New` = 'xyz' WHERE `id` = '5000'
Is this efficient or is there a better faster way of doing it? 'Am a newbie, hence Will appreciate a nod or any advice.