Not sure how to properly go about doing this.
I have my users table with about 500,000 already existing rows.
I'm creating a playlist feature for my music community, so I have a table called playlists. I'd like to give each of the 500,00 users a default playlist called Favorites.
What is the best way to do this?
Should I call the users table and loop through the data? Upon each loop, I insert the USERID into the playlists table? Is there a more efficient process?