Write CSV to MySQL with Python

#!/usr/bin/python
# -*- coding: utf-8 -*-
#
import argparse
import sys
import csv
import mysql.connector
connection = mysql.connector.connect(host='db_server.com', user='username', passwd='password', db='db_name')
cursor = connection.cursor()
query = "LOAD DATA LOCAL INFILE 'C:/analytics/GA_data_yesterday.csv' INTO TABLE db_name.table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES"
cursor.execute( query )
connection.commit()