刚看了下基本的一些简单的SQL语句:顺便在这儿做个记录:
SELECT orders.*,
user.username,
user.sex,
user.address,
user.birthday
FROM mybatis.orders,mybatis.user where orders.user_id=user.id;
SELECT orders.*,
user.username,
user.sex,
user.address,
user.birthday,
orderdetail.id orderdetail_id,
orderdetail.items_id,
orderdetail.orders_id,
orderdetail.items_num
FROM mybatis.orders,mybatis.orderdetail,mybatis.user
where orders.user_id=user.id and orders.id=orderdetail.orders_id;
SELECT orders.*,
user.id userid_id,
user.username,
user.sex,
user.address,
user.birthday,
orderdetail.id orderdetail_id,
orderdetail.items_id,
orderdetail.orders_id,
orderdetail.items_num,
items.createtime items_createtime,
items.detail,
items.id item_id,
items.name item_name,
items.pic,
items.price
FROM mybatis.orders,mybatis.orderdetail,mybatis.user,mybatis.items
where orders.user_id=user.id and orders.id=orderdetail.orders_id and items.id=orderdetail.items_id;
SELECT
user.id,
user.username,
user.sex,
items.name item_name,
items.price
FROM mybatis.orders,mybatis.orderdetail,mybatis.user,mybatis.items
where orders.user_id=user.id and orders.id=orderdetail.orders_id and
items.id=orderdetail.items_id;
select * from mybatis.user,mybatis.orders where orders.user_id=user.id;
select * from mybatis.orders;
//这是延迟加载的一种简单的查询方法语句
select orders.*,
(select username from mybatis.user where user.id=orders.user_id)username,
(select sex from mybatis.user where user.id=orders.user_id)sex,
(select birthday from mybatis.user where user.id=orders.user_id)birthday,
(select address from mybatis.user where user.id=orders.user_id)address
from mybatis.orders;
这些都是最基本的语句关联查询。注意这儿有的语句使用到了别名。