我尝试使用python2.7中的MySQLdb模块将csv表上载到MySQl表中。在import MySQLdb
connection = MySQLdb.connect(host="localhost", user="root", passwd="password", db="test")
cursor = connection.cursor()
query = '''USE test; DELETE FROM test2; LOAD DATA LOCAL INFILE "C:/data/data.csv" INTO TABLE test2 COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;'''
cursor.execute(query)
connection.close()
我在phpmyadmin上尝试过查询,它允许我传输所有的行(除了最上面的行,它只是列的名称),但是当我尝试在Python2.7中运行查询时,我得到了多条错误消息。在
错误1:Syntax error: Invalid Syntax pointing to the ENCLOSED BY section.
当我在查询中添加3个单引号时,我得到一条错误消息“
错误2:Exception _mysql_exceptions.OperationalError: (2013, 'Lost connection
to MySQL s erver during query') in (bound method Cursor__del__ of
MySQLdb.cursors.Cursor object at 0x0233AAF0) ignored
我不知道该怎么办。我做了一天中大部分时间的研究,尝试了不同的变化,但我什么也没有。你的帮助将不胜感激。在