I have a table called
events defined as follow:
content_id is the IDs in other tables.
event_type should be kind of array containing this values:
[ "rep_login", "rep_share", "email_viewed", "brand_page_opened", "media_viewed", "rep_contacted", ]
I need to insert 10k rows on
events table but compliance with these conditions:
- Each row should contains UNIQUE values for each column
event_typeshould be randomize for populate the table with several event types
This data is for testing purpose. Can this be done from MySQL query? How?