Import CSV File Data in MySQL Db
Rules to import csv data:
- Only files with .csv extension are allowed.
- 2 MB is max file size allowed.
- No more than 6 rows of csv file.
- id, name & email are mandatory fields.
- id must be progressive.
Records added to the database:
| ID |
Name |
Email |
Created on |
| 1 |
James Dean |
jamesdean@gmail.com |
2023-04-26 17:59:36 |
| 2 |
Alen Delon |
alendelon@tin.it |
2023-04-26 17:59:36 |
| 3 |
Muhammad Ali |
mali@gmail.com |
2023-04-26 17:59:36 |
| 6 |
Marco Bianchi |
mbianchi@gmail.com |
2023-04-26 18:15:34 |
| 7 |
Paolo Rossi |
prossi@hotmail.com |
2023-04-26 18:15:34 |
| 8 |
Giuseppe Festa |
gfesta7@gmail.com |
2023-04-26 18:15:34 |
| 9 |
Michael Shumaker |
shumi@gmail.com |
2023-04-26 18:50:48 |
| 10 |
Niky Lauda |
lauda@hotmail.com |
2023-04-26 18:50:48 |
| 11 |
Airton senna |
asenna@gmail.com |
2023-04-26 18:50:48 |