python里load什么意思_如何从python中执行LOAD DATA命令

我该怎么做？在import MySQLdb

conn = MySQLdb.connect (

host = settings.DATABASES['default']['HOST'],

port = 3306,

user = settings.DATABASES['default']['USER'],

passwd = settings.DATABASES['default']['PASSWORD'],

db = settings.DATABASES['default']['NAME'],

charset='utf8')

cursor = conn.cursor()

cursor.execute('SELECT COUNT(*) FROM auth_user')

print cursor.fetchall() # this prints, so I know the connection is correct

cursor.execute('''

LOAD DATA INFILE 'a_short.csv' INTO TABLE export

FIELDS TERMINATED BY '|' ENCLOSED BY '"'

LINES TERMINATED BY '\r\n'

IGNORE 1 LINES;

''')

当我尝试上面的操作时，我得到一个“accessdenied”错误，但是我认为它与试图从游标内部执行LOAD DATA命令有关。正确的方法是什么？在

更新：这似乎是Amazon RDS中用户权限的限制(没有“文件”权限)。有一种方法可以解决这个问题：how to 'load data infile' on amazon RDS?。在