MySQL Forums
Forum List  »  MySQL Workbench

Re: Importing CSV Data
Posted by: Peter Brawley
Date: August 01, 2019 08:46AM

You'll need to ...

1 get familiar with the Load Data Infile command

2 write and debug a sql script that invokes Load Data Infile for one of your files

3 if you want to do it in WorkBench, you'll need to get familar with WB's interface for that cmd

4 write a script (bash on Linux or Mac, batch on Win) like that shown in https://stackoverflow.com/questions/8538995/how-to-import-multiple-csv-files-into-a-mysql-database for all .csv files in the folder

Options: ReplyQuote


Subject
Views
Written By
Posted
83
August 01, 2019 08:05AM
Re: Importing CSV Data
51
August 01, 2019 08:46AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.