(1054, "Unknown column 'm' in 'field list'")

Question

i have create a mysql table like----> create table test(gender char(1));

my python sudo code is---->

from pymysql import *
g='m'
sql='insert into test values(%s)' %g
cur.execute(sql)
con.commit()
con.close()

but its giving me error ---> (1054, "Unknown column 'm' in 'field list'")

plz help me out to solve it

The error message is quite explanatory. What are you not understanding? — Frédéric Hamidi, Oct 14 '13 at 12:44
I know that is not the answer, but Why don't you try to use a full "INSERT INTO test () VALUES ()" sentence? — opalenzuela, Oct 14 '13 at 12:44

score 3 · Answer 1 · edited May 23 '17 at 12:21

3

The

'insert into test values(%s)' %g

expands to

'insert into test values(m)'

which is clearly not what you want (what is m?)

My recommendation is to use bind parameters:

g = 'm'
sql = 'insert into test values(?)'
cur.execute(sql, g)

edited May 23 '17 at 12:21

Community

answered Oct 14 '13 at 12:46

NPE

score 1 · Answer 2 · answered Dec 10 '14 at 12:20

1

You should try this:

'insert into test () values('%s')' %g ... this is because the variable g is aString` and after the append that you are doing this must look like:

"insert into test () values('m')" and not "insert into test () values(m)"

<>

cheers

answered Dec 10 '14 at 12:20

2 Answers2