Iepirkumu groza datu bāzes kods
- --创建数据库
- create database itsvseshop
- go
- use itsvseshop
- go
- --创建用户表
- create table tb_User
- (
- UserID int identity(1,1) primary key,
- UserName varchar(10) not null,
- TPassWord varchar(10) not null,
- Tmoney money
- )
- create table tb_GoodsInfo
- (
- GoodsID int identity(1,1) primary key,
- GoodsName varchar(20),
- GoodsKind varchar(20),
- GoodsPhoto varchar(50),
- GoodsPrice money,
- GoodsIntroduce varchar(50)
- )
- --插入用户数据
- insert into tb_User values('1','123','500')
- insert into tb_User values('2','123','6000')
- --插入商品
- insert into tb_GoodsInfo values('杯子','生活用品','image/水杯.bmp','5','喝水用的')
- insert into tb_GoodsInfo values('笔记本电脑','电器','image/图片2.jpg','6000','玩游戏用的')
- insert into tb_GoodsInfo values('牙刷','生活用品','image/牙刷.jpg','6','洗脸用的')
- --查询数据
- select * from tb_User
- select * from tb_GoodsInfo
|
Publicēts 08.04.2015 11:45:02
|
|
|
|
Saimnieks