Loading…

How to upload a large file through phpmyadmin in MySQL?

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’

BY Admin ON 21 Dec 2018
View Suggestions OR Post Your Suggestion

Suggest An Answer

No suggestions avaliable!

Latest post from Mysql Interview Questions

Joins in MySql
Joins in MySql
What's the difference between Oracle and MySQL
What's the difference between Oracle and MySQL

Most Searched Questions

Angular Interview Questions

Latest Blogs

How to Best Prepare Yourself with MongoDB Interview Questions
How to Best Prepare Yourself with MongoDB Interview Questions

3 days ago

Angularjs or reactjs Which is Better
Angularjs or reactjs Which is Better

6 days ago

Joins in MySql
Joins in MySql

1 week ago

Why Node.Js is better than PHP
Why Node.Js is better than PHP

1 week ago

How should I start JSP and Servlet
How should I start JSP and Servlet

1 week ago

Benefits of Laravel Over Other PHP Frameworks
Benefits of Laravel Over Other PHP Frameworks

2 weeks ago

7 benefits of AngularJS 2
7 benefits of AngularJS 2

2 weeks ago

Best PHP framework 2019
Best PHP framework 2019

2 weeks ago

What Are Some Interview Questions For Wordpress Developers
What Are Some Interview Questions For Wordpress Developers

3 weeks ago

What's the difference between Oracle and MySQL
What's the difference between Oracle and MySQL

3 weeks ago

PHP Interview Questions

Featured Category

Java Interview Questions

Ask Question