MySQL这样写UPDATE语句,直接劝退!
Java专栏
共 1293字,需浏览 3分钟
· 2021-11-15
![](https://filescdn.proginn.com/bce0889ae2e390946c0506dc02493c12/0d884e2417538ebd88280a2635fbbbdc.webp)
牛逼!又发现了一款面试题库,太全了!!
(点击查看)
![](https://filescdn.proginn.com/20bbccee83c4f7e66343ec59c30a71f8/9338dfc5dbdec3fba6d99abb27d9d209.webp)
update apps set owner_code='43212' and owner_name='李四' where owner_code='13245' and owner_name='张三';
![](https://filescdn.proginn.com/ed055cadae834093fb092f79c5c5561d/d059a3fc108631c7ca170c79189e3898.webp)
![](https://filescdn.proginn.com/ba669c46cf5f20b3022dc4e1fc531c40/92422d7efd483a6133cf4061c13c19ea.webp)
owner_name的值没有变,但owner_code变成了0!
![](https://filescdn.proginn.com/10d8bfaf4fc0093c6681b34ca966c0a0/458115abb1435122d50d879da9ef9621.webp)
update apps set owner_code='43212' , owner_name='李四' where owner_code='13245' and owner_name='张三';
![](https://filescdn.proginn.com/c6c907e463dabad859d3ff03d5e7d76d/44c4ef1e34ed97b165bd3e822d7cf4c9.webp)
update apps set owner_code='43212' and owner_name='李四' where owner_code='13245' and owner_name='张三';
等价于:
update apps set owner_code=('43212' and owner_name='李四') where owner_code='13245' and owner_name='张三';
如有文章对你有帮助,
欢迎关注❤️、点赞👍、转发📣!
![](https://filescdn.proginn.com/4df82a1ab4159fc8089d7f1d1aa1dbb0/61b38c9838e9014c971f2a3036d3f280.webp)
评论