Enable me to import csv data into MySQL database phpMyAdmin

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'.

Skills: Javascript, MySQL, PHP

See more: import csv database, phpmyadmin mysql import csv, phpmyadmin import csv, mysql import csv, phpmyadmin enable csv import, mysql table csv, id me, can you please let me know, better than javascript, import mysql, import database, import csv, enable, data importing, csv, csv php, csv import, csv data, Appointment booking, mysql database import, import data php website, database javascript, php table csv, import csv data mysql, mysql import csv data

About the Employer:
( 21 reviews ) Swadlincote, United Kingdom

Project ID: #1297313

Awarded to:


I can create a script to import CSV events in bulk into your MySQL database. Thanks, Suresh

£30 GBP in 1 day
(549 Reviews)

14 freelancers are bidding on average £39 for this job


NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

£20 GBP in 0 days
(77 Reviews)

Professional Web Developer is ready get started right now. More information in Private Message.

£60 GBP in 2 days
(94 Reviews)

hi,i saw your project description. I will do that on time. I will do custom design and coding for you. Please check my profile and [url removed, login to view]

£40 GBP in 0 days
(84 Reviews)

hi sir, please check pmb. thanks ^_^

£20 GBP in 1 day
(69 Reviews)

Hi, could you check pm please?

£30 GBP in 2 days
(39 Reviews)

i can do this ... check you PMB....

£30 GBP in 0 days
(10 Reviews)

Hi. Please check your inbox for my message

£30 GBP in 0 days
(5 Reviews)

please check PMB

£20 GBP in 1 day
(1 Review)

Respected sir I can do this for you. Please check your message box for details Thanks

£30 GBP in 1 day
(0 Reviews)

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.

£120 GBP in 2 days
(0 Reviews)

I m doing that. Please find file and link I am gonna send you.

£60 GBP in 1 day
(0 Reviews)

I'm going to develop PHP script with simple interface, that you can use anytime you want your database to be updated.

£20 GBP in 1 day
(0 Reviews)

I m ready to do this. By creating store procedure which you execute on mySQL DB.

£30 GBP in 1 day
(0 Reviews)