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