1,修改1列 update student s, city c set s.city_name = c.name where s.city_code = c.code; 2,修改多个列 update a, b set a.title=b.title, a.name=b.name where a.id=b.id •子查询 updat...
问题一: 会报错的写法: GRANT ALL PRIVILEGES ON *.* ‘root'@'%' identified by ‘123123' WITH GRANT OPTION; 以下是正确的写法: grant all privileges on *.* to ‘root'@'%' ; 可见,...