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
597
August 01, 2019 08:05AM
Re: Importing CSV Data
382
August 01, 2019 08:46AM


Sorry, you can't reply to this topic. It has been closed.

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.