How to upload a large file through phpmyadmin in MySQL?

1.	How to upload a large file through phpmyadmin in MySQL?
Answer» It is the best way to upload large CSV FILES through the LOAD DATA command. Syntax: LOAD DATA LOCAL INFILE "your file NAME" INTO TABLE table name FIELDS TERMINATED by ’,’ LINES TERMINATED BY ’\n’

Answer»

It is the best way to upload large CSV FILES through the LOAD DATA command.

Syntax:

LOAD DATA LOCAL INFILE "your file NAME"

INTO TABLE table name

FIELDS TERMINATED by ’,’

LINES TERMINATED BY ’\n’

Discussion