Retrieving possible list for use in a subsequent INSERT

Denis McMahon denismfmcmahon at
Fri Nov 1 20:12:14 CET 2013

On Thu, 31 Oct 2013 11:32:29 +0200, Nick the Gr33k wrote:

> The error seen form error log is:

> [Thu Oct 31 09:29:35 2013] [error] [client]
> pymysql.err.InternalError: (1241, 'Operand should contain 1 column(s)')

> (cID, refs, host, city, useros, browser, visits, downloads) )

I suspect the issue is that, as a list type, the pysql interface expects 
to map "downloads" to either multiple columns, or one column in multiple 
rows, ie it is expecting the list to deliver multiple data items to the 
database, but the database is looking for a single data item.

Denis McMahon, denismfmcmahon at

More information about the Python-list mailing list