dang7758的博客

猜测: 关联查询条件写在on后面，先过滤再关联，关联条件是正常的关联 where后面，先关联，在查询 DROP TABLE IF EXISTS `t1`; CREATE TABLE `t1` ( `s1` int(11) DEFAULT NULL, `s2` char(5) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; INSER...

https://dev.mysql.com/doc/refman/8.0/en/update.html UPDATE student s INNER JOIN teacher t ON s.manager_id = t.id SET s.manager_name = t.`name` where s.id=1