-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathREADME
More file actions
22 lines (16 loc) · 773 Bytes
/
README
File metadata and controls
22 lines (16 loc) · 773 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
mysqltocsv.py connect to a MySQL Server, send a query,
and, with the result set, make CSV to the standard output.
mysqltocsv.py is written in Python, need the MySQLdb extension,
and use the Python internal CSV module.
Options are :
--host=host_name, -h host_name : MySQL Hostname
--port=port_num, -P port_num : MySQL Port
--user=user_name, -u user_name : MySQL Username
--password[=password], -p[password] : MySQL Password
--database=db_name, -D db_name : MySQL Database
--execute=statement, -e statement : MySQL SELECT Query
--fields-enclosed-by : CSV Enclosed Character
--fields-escaped-by : CSV Escaped Character
--fields-optionally-enclosed-by=string
--fields-terminated-by : CSV Field Terminated by
--lines-terminated-by : CSV Lines Terminated by