#设置客户端连接服务器端的编码
set names utf8;
#丢弃数据库,如果存在
drop database if exists xz;
#创建新的数据库,设置存储字符的编码
create database xz charset=utf8;
#进入创建的数据库
use xz;
#创建分类表
create table family(
fid int primary key,
fname varchar(8) not null unique
);
#插入数据
insert into family values
(20,'戴尔'),
(30,'小米');
insert into family values(10,'联想');
insert into family values(40,'华硕');
insert into family values(50,'神州');
#创建商品表
create table laptop(
lid int primary key auto_increment,
title varchar(128) unique,
price decimal(7,2) default 50000, #99999.99
spec varchar(32),
shelfTime date,
isOnsale boolean,
familyid int,
#把familyid作为外键,取值必须在family表的fid出现过
foreign key(familyid) references family(fid)
);
#插入数据
insert into laptop values(1,'小米Air',null,'商务版','2021-5-1',1,30);
insert into laptop values(2,null,5399,'游戏版','2018-1-1',1,20);
insert into laptop values(3,null,2199,'入门版','2015-1-1',0,10);
#应用默认值
insert into laptop(lid,title) values(4,'汪星人');
insert into laptop values(5,'华为',default,default,default,default,default);
insert into laptop(lid,title) values(null,'外星人2');
insert into laptop(lid,title) values(null,'外星人3');
insert into laptop(lid,title) values(null,'外星人4');
MySQL查询应用
于 2022-04-01 16:24:14 首次发布