Question

I m试图在数据库中添加字典价值。但是,一米的错误: 。 I m 采用这一代码。

       `cols = filter_dict.keys()
        vals = filter_dict.values()
        ("INSERT INTO table (%s) VALUES (%s)", [cols, vals])
`

When I only print this query ("INSERT INTO table (%s) VALUES (%s)", [cols, vals]). I m getting following output. ( INSERT INTO table (%s) VALUES (%s) , [[ cinematography , name , producer , caption , studio , editing ], [ Venkat Prasad , 100% Love , Bunny Vasu , , 100% Love Poster.jpg , Chandra Sekhar T Ramesh,Hari Prasad ]])

But When I execute this query I"m getting strange output. the manual that corresponds to your MySQL server version for the right syntax to use near table ((" cinematography ", " name

Why execute query adding ` to each columns?? Can any one help me? thanks

Answer 1

可能由于你的夸张而引起紧张。你们是否在互动的迅速执行你的守则?

无论如何,actual的问题是:

table is a reserved word. You should put table in backticks.
If your table contains more than one column, you need to have multiple %s and multiple values.

例如:

"INSERT INTO `table` (%s, %s, &s) VALUES (%s, %s, %s)"

您还需要修改<条码>(栏目、阀值),以列出各项数值。

(cols[0], cols[1], cols[2] , vals[0], vals[1], vals[2])

I d also strongly suggest that you try to find a better name for your table, preferably one that:

(1) 说明表中包含哪类数据,

2)无保留词

友情链接