编辑代码

create datebase pets:
use pets:
create datebase pet_info(
name varchar(32)primary key,
weight float,
height int,
type varchar(32),
age int,
color varchar(32);
insert pet_info,
values('Mike',3,28,'吉娃娃’,10,‘白’);
insert pet_info,
values('sala',6.5,40,‘柴犬’,15,‘黄’);
insert pet_info,
values(‘黑狮’,21.5,45,‘藏獒’,26,‘黑’);
insert pet_info,
values(‘大圣’,15,42,'牧羊犬',20,‘黄’);
insert pet_info,
values('Boy',5.5,24,'蝴蝶犬',6,‘白’);
select*form pet_info,
select name,type where color‘白’;
select*foem pet_info where weight<10 and height<30;
update pet_info set height=26.5 where name='Boy';
delete form pet_info where type=‘牧羊犬’