New answers tagged

0

Here is my thought: Create a table with all the fields that exist in the csv file. Create a trigger (After insert on the table created in step 1) that calls your procedure that you already have, or let the trigger itself insert new values to the corresponding tables. Load the CSV file to the table you created in step 1 The other tables will be populated ...


0

Although the above answer solved the problem for the OP, I feel I should contribute regarding how I solved the same problem. Error 13 is caused by incorrect or insufficient file permissions. In my case this was down to SELinux. The fix for adding your data file path to the permitted directories for MySQL can be found in this answer: ...



Top 50 recent answers are included