求数据库语句解题过程,具体解题步骤,求解求解
正确的 要交了。今天就要答案
create table Bpurchase_list(
id int(11) primary key auto_increment,
gname varchar(33) not null,
price float(9,2),
create_time timestamp
);
insert into Bpurchase_list
values (1,"苹果手机",5688,now()),
(2,"苹果手机",5688,now()),
(3,"华为手机",6688,now()),
(4,"vovio手机",5688,now()),
(5,"oppo手机",5688,now());
select * from Bpurchase_list;
create table Bcustomer(
id varchar(11) primary key,
name varchar(20) unique not null,
sex enum('男','女','保密'),
age int(2),
phone varchar(11) not null,
add_time timestamp default CURRENT_TIMESTAMP,
dj int(2),
check (dj<=5)
);
insert into Bcustomer
values
('1','aa','男',18,'18818881884',now(),1),
('2','bb','男',18,'18818881884',now(),1),
('3','cc','男',18,'18818881884',now(),3),
('4','dd','男',18,'18818881884',now(),2),
('5','we ','男',18,'18818881884',now(),4);
select * from Bcustomer;
什么叫图形化方法,这题目出的
您好,我是有问必答小助手,您的问题已经有小伙伴帮您解答,感谢您对有问必答的支持与关注!