mysql 基本查询汇总(隐式内连接、排序)

refer

select orders.*,user.* from orders,user where user.id=orders.user_id order by orders.user_id

排序查询:

1.查询所有的商品，按价格进行排序.(asc-升序,desc-降序)
select * from products order by price desc;
2.查询名称有新的商品的信息并且按价格降序排序.
select * from products where pname like '%新%' order by price desc;
3.查询0-10行的公告信息(按照 更新日期降序排列,最新的在最上面)
select * from notice order by n_time desc limit 0,10

练习:
查询用户的订单,没有订单的用户不显示
隐式内连接:

select user.*,orders.* from user ,orders where user.id=orders.user_id;