一.建立数据库
create database animal;
create table animal(
sno int,
name varchar(20),
weight varcahr(20),
color varchar(20),
birth date
);
插入数据
insert into animal values('1','狮子','200kg','黄色','2014-07-30'),('3','老虎','180kg','黄色','2010-02-14'),('2','猴子','20kg','棕色','2003-04-14'),('6','大象','1000kg','黑色','2009-07-12'),('5','长颈鹿','700kg','黄色','2007-07-13');
如图: