使用数据库插入时老是报错1054,而且还不是网上搜到的错误原因,经过测试多次才搞定,错误原因及改正如下:
原代码:
with conn:
cursor = conn.cursor()
for i in range(testnow.shape[0]):
dx, dy, oc, ot, x, y, house_id = testnow.iloc[i:i+1].values[0]
print ( house_id, dx, dy, oc, ot, x, y)
cursor.execute('insert into obj_infos (house_id, dx, dy, oc, ot, x, y) values ({}, {}, {}, {}, {}, {}, {})'.format(house_id,
dx, dy,