All ideas
project 3 case 2
I am trying to load the file using LOAD DATA INFILE 'C:/Program Files/MySQL/MySQL Server 8.0/Upload/users.csv' INTO TABLE users FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS; But the path shown was different 'C:/ProgramData/MySQL/MySQL Server 8.0/Upload/users.csv' I don't have program data folder i tried to create the folders according to the mentioned path but all the data is lost. I imported the users file by converting csv file into text file and inserted the rows in the table. But for the events table the same method is taking too long just to paste the data.
