mysql data to csv

mysql-to-csv.py

# requirement: python-mysqldb

import MySQLdb as dbapi
import sys
import csv

QUERY = 'SELECT * FROM mydb.people;'
db = dbapi.connect(host='localhost', user='root', passwd='password', db='dbname')

cur = db.cursor()
cur.execute(QUERY)
result = cur.fetchall()

c = csv.writer(open('dbdump01.csv', 'wb'))
for x in result:
    c.writerow(x)

mysql-to-csv.sql

SELECT order_id,product_name,qty
FROM orders
WHERE foo = 'bar'
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';