I have a tabel I use to collect customer reviews.
Aside form a few other fields the back bone are the ‘id’ and ‘password’ fields. Which are printed on cards for users to access the review area in order to input their reviews.
I set up the table originally with 10,000 rows, each with the id auto incremented and with a random eight character password. Now those 10,000 rows have been used.
So I need to add another 10,000 rows to the table with a password for each. So here’s my question:
Is there a way I can add 10,000 rows to the table AND generate an automatic password for each one as it is set up using SQL?