1.语法:update 表名 set某一项值=’ ’ where 限定条件
2.UPDATE boys SET boyName='张飞',userCP=10 WHERE id = 2;
3.UPDATE boys bo RIGHT JOIN beauty b ON bo.id = b.
boyfriend_idSET b.
boyfriend_id=2 WHERE b.
boyfriend_idIS NULL
1.语法:update 表名 set某一项值=’ ’ where 限定条件
2.UPDATE boys SET boyName='张飞',userCP=10 WHERE id = 2;
3.UPDATE boys bo RIGHT JOIN beauty b ON bo.id = b.
boyfriend_idSET b.
boyfriend_id=2 WHERE b.
boyfriend_idIS NULL