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’
Laravel Interview Questions
107
WordPress Interview Questions
77
React js interview questions
34
JavaScript interview questions
33
JQuery interview questions
51
Angularjs Interview Questions
39
html Interview Questions
33
html5 Interview Questions
36
CSS interview questions
35
Node js Interview Questions
69
Python Interview Questions
54
SQL Interview Questions
25
Mysql Interview Questions
62
MongoDB Interview Questions
24
PHP interview questions
95
