How do I create a script to run MySQL command line?

Question

I'm trying to import about 20 .csv files into MySQL and I'm fed up with doing it via phpmyadmin's import gui.

Is there a way to do this by batch without typing on the command line? i.e. a script that will run when double clicked (Windows). What I want is:

I have files like porsche.csv, ferrari.csv etc
I want to import each of these into tables with the same name (i.e. porsche, ferrari)
Empty the table before importing the text file (using delete flag). How does it handle new fields?
Ignore first line (header).

From what I've gathered so far: we use mysqlimport: http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

I'll try to fiddle around with the options and see if I can get something working.

Clickable from a Mac desktop? Windows? BeOS? :) mysqlimport would work nicely, really it's a question of what scripts are available in your environment. — Dave S.
– Dave S., Commented Mar 14, 2013 at 15:30

Community · Accepted Answer · 2017-05-23 12:21:05Z

0

On Windows, the easiest way is to use a batch script.

Read the documentation on available options.

The batch script would look something like:

@echo off
cd C:\Program Files\MySQL\MySQL Workbench 5.2 CE\

mysqlimport ...

2 Comments

meiryo Over a year ago

Trying to do a mysqlimport --local "C:\Users\Desktop\dude.csv" but the file cannot be found. Are we limited to the `C:\Program Files\MySQL\MySQL Workbench 5.2 CE` directory?

Kermit Over a year ago

@meiryo Not at all. That just points to the directory that contains your mysql instance.

Collectives™ on Stack Overflow

How do I create a script to run MySQL command line?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related