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)
);
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,'广东');