company管理系统

create database company;

show databases;

create table goods(

  id  int  primary key,

  name  varchar(20)  Not null,

  price float(3,1),

  product_time  year,

  validity_time tinyint,

 address varchar(80)  );

desc  goods;

insert into goods values(001,"apple",2,2017,3,"anqing");

insert into goods values(002,"banana",3,2017,2,"bengbu");

insert into goods values(003,"peach",4,2017,4,"wuhu");

insert into goods values(004,"pear",3,2017,4,"fuyang")

select * from  goods;

select *from goods where id =2;