网页制作师培训机构/seo优化必备技巧

这里的话在最下面括号外加charset = 'utf-8’

出现错误：Incorrect string value: ‘\xC0\xD6\xC6\xF7’ for column ‘tName’ at row 1
将数据库编码格式改为utf-8
alter table 表名称 convert to character set utf8;

————————————————————————————————————————

课后实践习题：


对应解答：

一.
create database OnlineDB;
二.
(会员信息表)
create table Users(uID int(4) primary key auto_increment not null comment "会员ID",uName varchar(30) not null comment "用户名",uPwd varchar(30) not null comment "密码",uSex varchar(2) default "男" comment "性别",uBirth datetime(6) comment "出生日期",uPhone varchar(20) comment "电话",uEmail varchar(50) comment "电子邮箱",uQQ varchar(20) comment "QQ号码",ulmage varchar(100) comment "用户头像",uCredit int(4) default 0 comment "积分",uRegTime datetime(6) comment "注册时间")charset='utf8';(商品类别表)
create table GoodsType(tID int(4) primary key auto_increment not null comment "类别ID",tName varchar(100) not null comment "类别名称");(商品信息表)
create table Goods(gdID int(4) primary key auto_increment not null comment "商品ID",tID int(4) not null comment "类别ID",gdCode varchar(50) not null comment "商品编号",gdName varchar(100) not null comment "商品名称",gdPrice float(8) default 0 comment "价格",gdQuantity int(4) default 0 comment "库存数量",gdSaleQty int(4) default 0 comment "已卖数量",gdCity varchar(50) default "长沙" comment "发货地",gdImage varchar(100) comment "商品图像",gdInfo text(16) comment "商品描述",gdAddTime datetime(6) comment "上架时间",gdHot int(4) default 0 comment "是否热销")charset='utf8';(购物车信息表)
create table Scars(ScID int(4) primary key auto_increment not null comment "购物车ID",uID int(4) not null comment "用户ID",gdID int(4) not null comment "商品ID",ScNum int(4) default 0 comment "购买数量");(订单信息表)
create table Orders(oID int(4) primary key auto_increment not null comment "订单ID",uID int(4) not null comment "用户ID",oTime datetime(6) not null comment "下单时间",oTotal float(8) not null default 0 comment "订单金额");（订单详细表）
create table OrderDetail(odID int(4) primary key auto_increment not null comment "详情ID",oID int(4) not null comment "订单ID",gdID int(4) not null comment "商品ID",odNum int(4) default 0 comment "购买数量",dEvalution varchar(8000) comment "商品评价",odTime datetime(6) comment "评价时间");三.
添加外键约束   中的是的外键
alter table Goods add constraint fk_tID foreign key(tID) references GoodsType(tID);  //Goods中的tID是GoodsType 的外键
alter table Scars add constraint fk_uID foreign key(uID) references Users(uID);      //Scars中的uID是Users的外键
alter table Scars add constraint fk_gdID foreign key(gdID) references Goods(gdID);   //Scars中的gdID是Goods的外键
alter table Orders add constraint fk_sec_uID foreign key(uID) references Users(uID); //Orders中的uID是Users的外键
alter table OrderDetail add constraint fk_oID foreign key(oID) references Orders(oID);  //OrderDetail中的oID是Orders的外键
alter table OrderDetail add constraint fk_sec_gdID foreign key(gdID) references Goods(gdID); //OrderDetail中的gdID是Goods的外键
添加唯一性约束
alter table Users add unique(uName);  //Users中的uName
alter table Goods add unique(gdName); //Goods中的gdName
添加默认值约束
alter table Goods add gdAddTime datetime(6) default getdate();   ?????获取默认值系统时间
alter table Goods add gdSaleQty int(4) default 0;   //这个是已经有默认值的了四.
insert into GoodsType set tName = "乐器";  //在goodstype中加入新类名称"乐器"
五.
insert into Goods set tID = 1,gdCode="099",gdName = "紫竹洞箫",gdPrice = "288" ,gdQuantity = 10, gdCity = "浙江";
六.
update Goods set gdQuantity = 5 where gdCode="099";  //更改记录是gdCode=099中的数量为5
七.
delete from Goods where gdName="紫竹洞箫";