Retrieving possible list for use in a subsequent INSERT
Denis McMahon
denismfmcmahon at gmail.com
Fri Nov 1 15:12:14 EDT 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 46.198.103.93]
> 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 gmail.com
More information about the Python-list
mailing list