编辑代码

CREATE DATABASE pets;
use pets;
CREATE TABLE pet_info (
	id int primary key,
	name varchar(32),
	weight float(32),
	height varchar(32),
    type varchar(32),
    age int(32),
    color char(32)
);
INSERT INTO pet_info(id,name,weight,height,type,age,color)values('1', 'mike', 3, 28,'吉娃娃',10,'白');
insert into pet_info(id,name,weight,height,type,age,color)values('2','sala',6.5,40,'柴犬',15,'黄');
 insert into pet_info(id,name,weight,height,type,age,color)values('3','黑狮',21.5,45,'藏獒',26,'黑');
 insert into pet_info(id,name,weight,height,type,age,color)values('4','大圣',15,42,'牧羊犬',20,'黄');
 insert into pet_info(id,name,weight,height,type,age,color)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';
 select*from pet_info;
 delete from pet_info where type='牧羊犬';
 select*from pet_info;