mysql 如何用UPDATE语句的问题

2024-12-25 10:50:54
推荐回答(3个)
回答1:

+"',password='"+password+"',email='"+email
+"',grade="+grade+" where userId="+userId

这几处是字符串需要加单引号

回答2:

这样用"UPDATE table1 SET address = 'King's Road“,” WS' WHERE name = ‘James’;
在,两侧加双引号“”

回答3:

UPDATE table1 SET address =“King's Road, WS” WHERE name = James