3

sql update where set 字段相同，这个要怎么写呢

2 years ago

source link: https://www.v2ex.com/t/806833
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

neoserver,ios ssh client

sql update where set 字段相同，这个要怎么写呢

kangsgo · 17 小时 23 分钟前 · 561 次点击

UPDATE fa_iot_order SET card_id=1 WHERE card_id =2;

我这么写会超时

1205 - Lock wait timeout exceeded; try restarting transaction

时间: 50.634s

第 1 条附言 · 13 小时 24 分钟前

谢谢大家，此问题已解决了，是数据库的不知道怎么回事查什么都锁了，重启数据库就好了

Recommend

About Joyk

Aggregate valuable and interesting links.
Joyk means Joy of geeK