Sql Server 与 MySql 在使用 update inner join 时的区别
-- 不使用别名UPDATE
tb_User
SET
tb_User.pass = ''
FROM
tb_User usr
INNER JOIN
tb_Address addr
ON
usr.nAddressFK = addr.nAddressID
WHERE
usr.id=123
-- 使用别名
UPDATE
usr
SET
usr.pass = ''
FROM
tb_User usr
INNER JOIN
tb_Address addr
ON
usr.nAddressFK = addr.nAddressID
WHERE
usr.id=123
页:
[1]