1.sql

来自「java编写的网络购物简洁版」· SQL 代码 · 共 42 行

create database chanpin
go
use chanpin
create table breed                             --类别表
(
breedID int identity(1,1) primary key not null,--类别ID
breedName varchar(20) ,                       --类别名称
bewrite varchar(20)                          --类别描述
)
insert into breed values('饮料','喝的')
insert into breed values('冷食','喝的')

--drop table breed
--drop table product
select * from breed
go
create table login
(
	name char(10),
	pass char(50),
	dengji int
)

insert into login(name,pass,dengji) values('admin','admin',1)
insert into login(name,pass,dengji) values('111','111',0)
go
create table product                             --产品表
(
productID int identity(1,1)primary key not null,--产品ID
breedID int not null,                           --类别ID
productName varchar(20),                      --产品名称
factory varchar(10),                            --出厂商
price float,                                      -- 价  格
amout int,                                       --数量
remark char(50)                                  --备注                                 
)
alter table product add constraint fk_breedID foreign key (breedID)references breed (breedID)

insert into product (breedID,productName,factory,price,amout, remark) values('1','雪碧','可口可乐','3',2,'eee')
insert into product (breedID,productName,factory,price,amout, remark) values('1','雪碧','可口可乐','3',2,'eee')
select * from product