MySQL insert single variable with python

Question

Im having problem with single value inserts. Using pyodbc

LL= []
....
sqla = 'INSERT INTO d.table VALUES (?,?,?,?,?,?,?)'
csr.executemany(sqla, LL)

Works, if LL is single column of data as a list...does not work.

LL= []
....
sqla = 'INSERT INTO d.table VALUES (?)'
csr.execute(sqla, LL)

How do I fix?

Then

LL= []
....
sqla = 'INSERT INTO d.table VALUES (?)'
csr.execute(sqla, LL)

If LL is Id only, The database table has cols of ID, AAA,BBB, CCC, How do I insert....

LL= [['TDW'], ['TD0'], ['TD0'], ['TDW'], ['TD10'] ]

Could we see a snippet of what LL looks like with data in it? — Marcelo Cantos
– Marcelo Cantos, Commented Mar 3, 2011 at 4:27

CyberDem0n · Accepted Answer · 2011-03-03 04:52:46Z

1

sqla = 'INSERT INTO d.table (column_name) VALUES (?)'

This is right syntax of INSERT QUERY.

answered Mar 3, 2011 at 4:42

CyberDem0n

15.1k1 gold badge37 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1