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,'廣東');

總結

以上是生活随笔為你收集整理的mysql 建表代码的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。