且构网

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

使用mysql/php的INSERT语句中的WHERE子句

更新时间:2023-02-05 09:11:26

那不是INSERT.这是 UPDATE . INSERT语句插入 new 行. UPDATE语句更新现有行.

That not an INSERT. That's an UPDATE. INSERT statements insert a new row. UPDATE statements update an existing row.

UPDATE issued_books
SET Book_4 = '$IssuedBookNumber'
WHERE Student_ID = '$Student_ID'

(我假设您已经正确逃脱了$IssuedBookNumber$Student_ID)

(I'm assuming you've properly escaped $IssuedBookNumber and $Student_ID)