Upsert data from CSV to MySQL table via command line on Windows

by

Want to upsert data from CSV file to existing MySQL table via command line on Windows?

Using my-cmd, you can upsert(merge) CSV/TSV/TXT data to MySQL (MariaDB, Percona) table easily and fast, no need to program.

Here you can download my-cmd Windows version.

No need to install MySQL client library.

Convenient to deploy to cloud. No need to run installation file, just uncompress and run, immediately.

Upsert/Merge CSV/TSV/TXT data into MySQL (MariaDB, Percona) table via command line on Windows

1. In interactive mode:

my-cmd> load loadtype=upsert
      > updatekey=id
      > table=media_messages 
      > datafile=f:\media_messages.csv 
      > delimiter=, 
      > quote=" 
      > header=y;

2. In batch mode:

my-cmd dsn="pan:withdata@192.168.0.102/test" task=load loadtype=upsert updatekey=id table=media_messages datafile=f:\media_messages.csv delimiter=, quote=" header=y quit=y

“loadtype=upsert” will update row in table if “updatekey” id exists, or insert new row.

See parameters detail.


More about my-cmd – the tool to upsert CSV/TSV/TXT data to MySQL (MariaDB, Percona) table via command line on Windows/Linux/MacOS

30-day free trial Download my-cmdUS$49.95 Buy my-cmd