擅长:python、mysql、java
<p>我认为您实际上希望向查询中添加一个<code>WHERE</code>子句来选择要更新的相关记录。这也意味着您需要对绑定值进行不同的排序:</p>
<pre><code>self.cur.execute('''
UPDATE car_info SET
owner_company=%s,
branch=%s,
service_mode=%s,
shaceh_number=%s,
motor_number=%s,
fuel_type=%s,
car_type=%s,
car_model=%s,
car_load=%s,
car_weight=%s,
car_shape=%s,
car_color=%s
WHERE car_number=%s''',
(
owner_company,
branch,
service_mode,
shaceh_number,
motor_number,
fuel_type,
car_type,
car_model,
car_load,
car_weight,
car_shape,
car_color,
car_number
)
)
</code></pre>