How to load data of .csv file in MySQL Database Table?

0 votes
I need to load many records from .csv file to MySql database table. Could you please suggest how can I do that? I'm using Edureka Cloudlab.
Jul 5 in Database by Freddy
19 views

1 answer to this question.

0 votes

At first, put the dataset in the local of the web console. 

After that execute the command as given in the below image:

image

answered Jul 5 by Reshma

Related Questions In Database

+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

answered Jan 4 in Database by Priyaj
• 56,160 points
62 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
136 views
0 votes
1 answer

What are the ways to get the count of records in a table

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,140 points
50 views
0 votes
1 answer

How to connect to MySQL Database?

using MySql.Data; using MySql.Data.MySqlClient; namespace Data { ...READ MORE

answered Oct 12, 2018 in Database by Frankie
• 9,810 points
69 views
0 votes
1 answer

Want a command to be executed in Salt only if a directory is empty

You should consider using this inside your ...READ MORE

answered Jun 12, 2018 in DevOps Tools by Damon Salvatore
• 5,490 points
32 views
0 votes
1 answer

Creating A New MySQL User In Amazon RDS Environment

AWS RDS security groups documentation (a common ...READ MORE

answered Jul 18, 2018 in AWS by Priyaj
• 56,160 points
90 views
0 votes
1 answer

Using conditional to execute a command in salt

You can use unless inside your state ...READ MORE

answered Jul 23, 2018 in Other DevOps Questions by DareDev
• 6,810 points
54 views
0 votes
1 answer

How can I check my all existing table in MySQL database?

Hi Pratik, I understand your problem regarding this ...READ MORE

answered Jul 1 in Database by Sampriti
• 860 points
18 views
0 votes
1 answer

How to install MySQL in Ubuntu?

To install MySQL on ubuntu you have ...READ MORE

answered Feb 28 in Database by Priyaj
• 56,160 points
32 views