每一段都不同 求大神帮帮忙啊！！！
alter table merchandise add constraint sid foreign key(sid) references supplier(sid);
alter table merchandise =10000; //设置从10000开始递增
create table user(
uid int identity primary key,
RegisterName varchar(20) not null,
post int not null,
md5 varchar(32) not null,
address varchar(50) not null,
sex enum('男','女') default "男",
name char(10) not null
);
create table booking(
bid int identity primary key,
uid int not null,
mid int not null,
value int not null,
money decimal(10,1) not null,
time date not null,
constraint uid foreign key(uid) references user(uid),
constraint mid foreign key(mid) references merchandise(mid)
);
create trigger user_booking before delete on user
for each row
begin
set @uid=old.uid;
delete from booking where uid=@uid;
end;

没人会么

分号的使用

把分号换成go

设置递增的那一条语句，我就不懂咯。暂时没学过。你把那个递增删除了，就可以运行了。