目的是要算同样的地区内,水果的排名并且更新自己ranking列:
于是如下sql:
UPDATE DistrictProducts2 P1
SET ranking = (
SELECT COUNT(P2.price) + 1
FROM DistrictProducts2 P2
WHERE P1.district = P2.district
AND P2.price > P1.price
);
但是这条语句在mysql上执行会报错:
[Err] 1093 - You can't specify target table 'P1</