Yet Another MySQL Problem

[MRAB]

Kushal Kumaran wrote:
[snip]
> Since I'm in a good mood today, here's a little present:
> 
> def insert(cursor, table, columns, values):
>     """Insert a row into a table.  columns must be a list of column
>     names.  values must be a list of values for the new row.  The
>     columns and values must correspond."""
>     assert len(columns) == len(values)
> 
>     stmt = """
> insert into %s (%s) values (%s)
> """ % (table,
>        ', '.join(columns),
>        ', '.join('%s' * len(values)))

That should be:

        ', '.join(['%s'] * len(values)))

>     logging.debug('stmt: %s, values: %s' % (stmt, values))
> 
>     cursor.execute(stmt, values)
> 
> Hope it helps.
>