如何在 MySQL Insert 语句中添加 where 子句?

2022-01-09 00:00:00 where-clause insert mysql

这不起作用:

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

任何想法如何通过 id 缩小对特定行的插入范围?

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

推荐答案

在插入语句中，您不会有一个现有的行来执行 where 子句吗?您正在插入一个新行，您的意思是要执行更新语句吗?

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';

相关文章