#1
SELECT `user` .*,uw.wallet_id,uw.balance from `user` join user_wallet uw on `user`.user_id=uw.user_id;
#2
#1
select * from order_info;
#2
select product_id '商品id' from order_info group by product_id order by count(*) desc limit 1;
#3
SELECT * from product p join product_type as pt on p.type_id=pt.type_id;
#4
SELECT * from product p join product_type as pt on p.type_id=pt.type_id
where product_id=(
select product_id '商品id' from order_info group by product_id order by count(*) desc limit 1
);
#3
#1
select user_id '用户编号' from `order` group by user_id order by sum(total_price) desc limit 1;
#2
select * from `user` u join user_wallet uw on u.user_id=uw.user_id
#3
select u.*,wallet_id,balance from `user` u join user_wallet uw on u.user_id=uw.user_id
where u.user_id=(
select user_id '用户编号' from `order` group by user_id order by sum(total_price) desc limit 1
);
MYSQL
最新推荐文章于 2024-09-14 19:55:29 发布