DROP TABLE IF EXISTS cart;
CREATE TABLE cart(
id int primary key auto_increment,
memberId int,
comment test ,
);
假如cart表存在就清除表
新建cart表,id,类型int,主键,
memberId ,类型int,
comment 类型test ,
DROP TABLE IF EXISTS member;
CREATE TABLE member(
id int primary key auto_increment,
name varchar(10) default null unique key,
pwd varchar(30) default 123456 ,
);
假如member表存在就清除
新建member表,id,类型int,主键
name 类型 varchar,不能重复不能为空
pwd类型 varchar默认123456
查看tom和jack 分别买的东西及评论,写了两种写法
select member.name,cart.goods,cart.comment from member,cart where member.id=cart.memberId and (cart.memberId=1 OR cart.memberId=2)
SELECT member.name,cart.goods,cart.comment from member
LEFT JOIN cart on cart.memberId=member.id where cart.memberId=1 or cart.memberId=2