7月25日项目 MySql约束与插入语句

MySql中插入语句的三种方式：

 

练习题目要求：

解答：Navicat中数据库中建立新建查询，创建各个表并插入数据

具体代码：

create table customer
(
   cid INTEGER(4) auto_increment primary key,
     cname varchar(20) not null,
     caddress varchar(30) not null,
     ccity varchar(20) not null,
     cstate varchar(20) not null,
     czip char(6) not null,
     ccountry varchar(10) not null,
     ccontact varchar(20) not null,
     cemail varchar(40) not null
);
create table product
(
   pid INTEGER(4) auto_increment primary key,
     pname varchar(20) not null,
     pprice varchar(10) not null,
     pdesc varchar(100) not null,
     pcount varchar(10) not null
);
create table orderr
(
  oid INTEGER(4) auto_increment primary key,
  pid INTEGER(4) not null,
  cid INTEGER(4) not null,
     ocount varchar(10) not null,
     oprice varchar(8) not null,
   odate datetime not null
);
create table vendor
(
   vid INTEGER(4) auto_increment primary key,
     vname varchar(20) not null,
     vaddress varchar(20) not null,
     vcity varchar(20) not null,
     vstate varchar(20) not null,
     vzip varchar(20) not null,
     vcountry varchar(10) not null
);
create table recruit
(
   rid INTEGER(4) auto_increment primary key,
     pid INTEGER(4) not null,
   vid INTEGER(4) not null,
     rprice varchar(8) not null,
     rcount varchar(10) not null,
     rreturncount varchar(10) not null,
     rdecp varchar(100) not null,
     rdate datetime not null
);
insert into customer(cname,caddress,ccity,cstate,czip,ccountry,ccontact,cemail)
   values('马云','大马路一号','杭州','浙江','100000','中国','马云','12345@163.com'),
     ('马云','大马路一号','杭州','浙江','100000','中国','马云','12345@163.com'),
     ('马云','大马路一号','杭州','浙江','100000','中国','马云','12345@163.com');
     
insert into product(pname,pprice,pdesc,pcount)
   values('MI NOTE2','2799','双曲面商务旗舰机','100'),
     ('MI NOTE2','2799','双曲面商务旗舰机','100'),
     ('MI NOTE2','2799','双曲面商务旗舰机','100');
     
insert into orderr(pid,cid,ocount,oprice,odate)
   values('1','1','1','2999','2011209'),
     ('1','1','1','2999','2011209'),
     ('1','1','1','2999','2011209');
     
insert into vendor(vname,vaddress,vcity,vstate,vzip,vcountry)
   values('雷军','蟠桃园','仙桃','湖北','4000000','中国'),
     ('雷军','蟠桃园','仙桃','湖北','4000000','中国'),
     ('雷军','蟠桃园','仙桃','湖北','4000000','中国');
     
insert into recruit(pid,vid,rprice,rcount,rreturncount,rdecp,rdate)
   values('4','5','4588','50','0','哈喽我的','20161209'),
     ('4','5','4588','50','0','哈喽我的','20161209'),
     ('4','5','4588','50','0','哈喽我的','20161209');