Fill table from local file - Error
Hello,
I am using python3.2 with mysql.connector. Though it works perfectly fine but for some reason I not being able to fill the table using it.
My code:
cur = con2.cursor(
cur.execute(
##Original query - LOAD DATA LOCAL INFILE "./scoring_
cur.execute("LOAD DATA LOCAL INFILE './scoring_
The error which I get is:
Table cleared successfully, update in process
Traceback (most recent call last):
File "./cl3_
TableUpload
File "./cl3_
cur.
File "/usr/lib/
res = self.db(
File "/usr/lib/
return func(*args, **kwargs)
File "/usr/lib/
return self.handle_
File "/usr/lib/
errors.
File "/usr/lib/
raise get_mysql_
mysql.connector
Please tell me how can I fill a table with a local file. As, when I run this query from my SQL the table is updated perfectly well. Its just that I am not being able to it from the script (code above). Awaiting Reply.
Thanks
Atul
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- Atul
- Solved:
- Last query:
- Last reply: