mysql 建表代码

1 需要建food表如下

2 food表需要加入记录如下

3 建立food表代码如下

CREATE DATABASE procedure_function DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TABLE food(
  id INT(10) PRIMARY KEY AUTO_INCREMENT NOT NULL,
  NAME VARCHAR(20) NOT NULL,
  company VARCHAR(30) NOT NULL,
  price FLOAT,
  produce_time YEAR,
  validity_time INT(4),
  address VARCHAR(50)
);

4 插入到food表中代码如下

INSERT INTO food(id,NAME,company,price,produce_time,validity_time,address) VALUES(1,'AA饼干','AA饼干厂',2.5,2008,3,'北京');
 INSERT INTO food(id,NAME,company,price,produce_time,validity_time,address) VALUES(2,'CC牛奶','CC牛奶厂',3.5,2009,1,'河北');
 INSERT INTO food(id,NAME,company,price,produce_time,validity_time,address) VALUES(3,'EE果冻','EE果冻厂',1.5,2007,2,'北京');
 INSERT INTO food(id,NAME,company,price,produce_time,validity_time,address) VALUES(4,'FF咖啡','FF咖啡厂',20,2002,5,'天津');
 INSERT INTO food(id,NAME,company,price,produce_time,validity_time,address) VALUES(5,'GG奶糖','GG奶糖厂',14,2003,3,'广东');