编辑代码

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