Want to append the data from CSV file to the existing MySQL table via command line on Linux (Ubuntu/RedHat/CentOS…)?
Using my-cmd, you can append CSV/TSV/TXT data into existing MySQL (MariaDB, Percona) table easily and fast, no need to program.
Here you can download my-cmd Linux version.
No need to install MySQL client library.
Convenient to deploy to cloud. No need to run installation file, just uncompress and run, immediately.
Append CSV/TSV/TXT data to existing MySQL (MariaDB, Percona) table via command line on Linux
1. In interactive mode:
my-cmd> load loadtype=append
> table=media_messages
> datafile=/data/media_messages.csv
> delimiter=,
> quote="
> header=y;
2. In batch mode:
my-cmd dsn="pan:withdata@192.168.0.102/test" task=load loadtype=append table=media_messages datafile=/data/media_messages.csv delimiter=, quote=" header=y quit=y
See parameters detail.