数据库概述
SELECT t2.name,t1.minPrice from test2 as t2 JOIN(
SELECT t.id,MIN(t.price)as minPrice from test AS t
GROUP BY t.type) as t1
on t2.id = t1.id
乐观锁
买家不是很多,可以使用乐观锁。
SELECT t2.name,t1.minPrice from test2 as t2 JOIN(
SELECT t.id,MIN(t.price)as minPrice from test AS t
GROUP BY t.type) as t1
on t2.id = t1.id
买家不是很多,可以使用乐观锁。