MySQL查询应用

#设置客户端连接服务器端的编码
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');