编辑代码

create database pets;
use pets;
create table pets_info(
id int primary key,
name varchar(32),
weight float,
height float,
type varchar(32),
age int,
color varchar(32));
insert into pets_info(id,name,weight,height,type,age,color)
values(1,'mike',3,28,'吉娃娃',10,'白');
insert into pets_info(id,name,weight,height,type,age,color)
values(2,'sala',6.5,40,'柴犬',15,'黄');
insert into pets_info(id,name,weight,height,type,age,color)
values(3,'黑狮',21.5,45,'藏獒',26,'黑');
insert into pets_info(id,name,weight,height,type,age,color)
values(4,'大圣',15,42,'牧羊犬',20,'黄');
insert into pets_info(id,name,weight,height,type,age,color)
values(5,'boy',5.5,24,'蝴蝶犬',6,'白');
select name,type from pets_info where color ='白';
select*from pets_info where weight<10 and height<30;
delete from pets_info where type='牧羊犬'; 
select*from
pets_info;