Script to export query results into local CSV files
Project description
Export MySQL query results to local CSV file.
Usage:
$ mycsv [-u username] [-p password] [-h hostname] [-p port] [-s query.sql] [-O output.csv]
If you omit password option you will got a prompt asking for the password (password will not be echoed):
$ mycsv -O report.csv < report.sql Password []:
You can send SQL script using stdin and dump CSV results to stdout:
$ mycsv -p Sekr3T < report.sql > report.csv
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
mycsv-0.1.3.tar.gz
(2.4 kB
view details)
File details
Details for the file mycsv-0.1.3.tar.gz
.
File metadata
- Download URL: mycsv-0.1.3.tar.gz
- Upload date:
- Size: 2.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6ec6f2f4c1614f3c69e2970231b25d5b93abaa1cf77b51cb7e660b3da44c35d3 |
|
MD5 | 91fc12a82db689f30e21e57bb208b208 |
|
BLAKE2b-256 | dcf8619ff4c17175208f27ce5b52cfb22f005b47500266855cc18a209642fc1e |