I have an appointment booking website, which runs from a MySQL database, I can add events one at a time in the admin section of the booking system, but I'd like to add events in bulk. To do this I would need to add new records to a table in the MySQL database.
I have a CSV file with the new dates and I would like to import this csv into the database through phpMyAdmin but I don't know how to do this.
I will add new dates every few months, so I will need to be given instructions of how to this - I don't mind using phpMyAdmin myself, but I would require instructions/commands from you.
Attached is a screenshot of the table from the MySQL database that needs records importing into it and also attached is a csv file that I have made with the new events.
If there is a better way to do this, rather than using a csv then please let me know - the only fields that will ever change are 'id', 'eventDate' and 'entryFee'.
14 freelancers are bidding on average £39 for this job
Hello, I can guide you how to insert data from csv. Also if you need I can make a program to insert data dynamically from csv to phpmyadmin. no phpmyadmin interface is required.