I have a mysql table having over a million rows with user information. I want to add a column 'password' in that table, randomly generate password and update all the records (using PHP).
What is the fastest way to perform this task?
Thanks in advance.