如何在MySQL Insert语句中添加where子句? [英] How to add a where clause in a MySQL Insert statement?

问题描述

这不起作用:

INSERT INTO users (username, password) VALUES ("Jack","123") WHERE id='1';

有什么想法如何通过id将插入范围缩小到特定行吗?

Any ideas how to narrow insertion to a particular row by id?

推荐答案

在插入语句中，您将没有现有行来执行操作?您要插入新行，是要做更新语句吗?

In an insert statement you wouldn't have an existing row to do a where claues on? You are inserting a new row, did you mean to do an update statment?

update users set username='JACK' and password='123' WHERE id='1';

这篇关于如何在MySQL Insert语句中添加where子句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！