201906G109/src/main/resources/db.sql

CREATE DATABASE `oms_final` DEFAULT CHARACTER SET utf8;

USE `oms_final`;

CREATE TABLE `orders` (
`id` int(11)  AUTO_INCREMENT PRIMARY KEY COMMENT '订单号',
`name` varchar(255) COMMENT '客户姓名',
`product_id` varchar(255) COMMENT '商品编号',
`charge` int(11) COMMENT '价格',
`address` varchar(255) COMMENT '收货地址',
`status` varchar(255) COMMENT '发货状态'
)DEFAULT CHARSET=utf8;

INSERT INTO `orders` VALUES (1,"蔡徐坤","p1",100,"中国","未发货");
-- total 6 columns
-- id,
-- name, product_id, charge, address, status