请提供用python把csv导入mySQL的代码

可以使用下面的代码来使用Python将csv文件导入MySQL：import csv
import MySQLdbmydb = MySQLdb.connect(host='localhost',
user='yourusername',
passwd='yourpassword',
db='yourdatabasename')cursor = mydb.cursor()csv_data = csv.reader(file('yourcsvfile.csv'))
for row in csv_data: cursor.execute('INSERT INTO yourtablename(column1, column2, column3,...)''VALUES(%s, %s, %s,...)', row)#close the connection to the database.
mydb.commit()
cursor.close()
print "Done"