- a CSV file (5000+ records);
- an empty
- am empty
- a number of other empty tables.
I would like to populate the
item table with the contents of the CSV file. Then I would like to create some foreign key relationships between both tables.
In what order do I do this?
I keep receiving an error every time I attempt this:
#1452 - Cannot add or update a child row: a foreign key constraint fails...
Note that my empty
favourite table already has some foreign key constraints set up. I am using PhpMyAdmin and MySQL Workbench.
Am I supposed to have all the tables populated with data before I set up foreign key relationships? Or do I set up the relationships then populate with data?