编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	id int,
	name varchar(255),
	address varchar(255),
	city varchar(255)
);
CREATE TABLE goods(
       id INT(11) PRIMARY KEY AUTO_INCREMENT COMMENT '商品编号',
       type VARCHAR(30) NOT NULL COMMENT '商品类别',
       name VARCHAR(30) UNIQUE COMMENT '商品名称',
       price DECIMAL(7,2) COMMENT '商品价格',
       num INT(11) DEFAULT 0 COMMENT '商品库存',
       add_time DATETIME COMMENT '添加时间'
);

INSERT INTO goods(id, type, name, price, num, add_time)
VALUES(1,'书籍','西游记',50.4,20,'2018-01-01 13:40:40'),
              (2,'糖类','牛奶糖',7.5,200,'2018-02-02 13:40:40'),
              (3,'糖类','水果糖',2.5,100,null),
              (4,'服饰','休闲西服',800,null,'2018-04-04 13:40:40'),
              (5,'饮品','果汁',3,70,'2018-05-05 13:40:40');


INSERT INTO student VALUES (1, '刘一', '郑十家隔壁', '河南');
INSERT INTO student VALUES (2, '陈二',  '李四家隔壁', '安徽');
INSERT INTO student VALUES (3, '张三',  '白娘子家隔壁', '杭州');
INSERT INTO student VALUES (4, '李四',  '许仙家隔壁', '杭州');
INSERT INTO student VALUES (5, '王五',  '李四家隔壁', '杭州');
INSERT INTO student VALUES (6, '赵六',  '赵六家隔壁', '杭州');
INSERT INTO student VALUES (7, '孙七',  '张三家隔壁', '杭州');
INSERT INTO student VALUES (8, '周八',  '雷峰塔附近', '杭州');
INSERT INTO student VALUES (9, '吴九',  '孙七家隔壁', '杭州');
INSERT INTO student VALUES (10, '郑十',  '周八家隔壁', '杭州');
 
-- SELECT * FROM student;

show tables;


SELECT * FROM goods;

SELECT id, type, name, price, num, add_time FROM goods;