During insert, I receive an error stating "Row 1 doesn't contain data for all columns"

[Dustin Krueger]

I am using pymysql to insert csv into a table. It works great until I add a primary key that is set to auto increment. At that time I receive an error stating "Row 1 doesn't contain data for all columns" This same command works just fine if I run it on mysql CLI. Hoping someone can tell me how to remove these errors and/or suppress them.

The full error message is:

"C:\Python27\lib\site-packages\pymysql\cursors.py:134: Warning: Row 1 doesn't contain data for all columns
  result = self._query(query)"

If I remove the Primary Key from the table, Everything works fine but this will not work for the project I am working on.

[INADA Naoki]

I think it's problem of mysql syntax, not pymysql.

What's your real table schema, query and parameters?

--
You received this message because you are subscribed to the Google Groups "PyMySQL Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pymysql-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

INADA Naoki  <songof...@gmail.com>