编辑代码

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','Sale',6.5,40,'柴犬',15,'黄');
insert into pet_info()
values('3','黑狮',21.5,45,'藏獒',25,'黑');
insert into pet_info()
values('4','大圣',15,42,'牧羊犬',20,'黄');
insert into pet_info()
values('5','boy',5.5,24,'蝴蝶犬',6,'白');
select*from pet_info;
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 ='牧羊犬';
select*from pet_info;