Python/MySQL: Inserting date into table using a variable table name

conn.execute("""insert into %s (a, b, c, d) values(%%s, %%s, %%s, %%s)""" %tablename,(a, b, c, d))