且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

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

更新时间:2023-01-19 23:39:20

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

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