编辑代码


create database pets;
use pets;
create table pet_info(
id varchar(32),
name varchar(32),
weight float,
height float,
type varchar(32),
age float,
color varchar(32)
);
insert into pet_info(id,name,weight,height,type,age,color)
values('1','mika',3,28,'吉娃娃',10,'白'),
('2','sala',6.5,40,'柴犬',15,'黄'),
('3','黑狮',21.5,45,'藏獒',26,'黑'),
('4','大圣',15,42,'牧羊犬',20,'黄'),
('5','boy',55,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;