#!/usr/bin/env python
import MySQLdb
import csv
HOST = "myshost"
USER = "myuser"
NAME = "myDB"
PASSWD = "mypass"
PORT = "myport"
def connect_db(host, port, user, password, db):
try:
return MySQLdb.connect(host=host, port=port, user=user, passwd=password, db=db)
except MySQLdb.Error, e:
sys.stderr.write("[ERROR] % d: % s\n" % (e.args[0], e.args[1]))
return False
def main():
QUERY="SELECT FIELD1,FIELD2,FIELD3 FROM MY_TABLE"
FILENAME="/home/ercan/dumps/dump.csv"
db = connect_db(HOST,int(PORT),USER,PASSWD,NAME)
dump_writer = csv.writer(open(FILENAME,'w'), delimiter=',',quotechar="'")
cur = db.cursor()
cur.execute(QUERY)
for row in cur.fetchall() :
dump_writer.writerow(row)
print("mysql query result export to csv file")
db.close()
if __name__ == "__main__":
main()
Comments
Post a Comment