第一题

/
创建订单结构表
/
order | CREATE TABLE order (
order_number char(20) DEFAULT NULL COMMENT ‘订单编号’,
commodity_name varchar(50) DEFAULT NULL COMMENT ‘商品名称’,
commodity_prices decimal(9,2) DEFAULT NULL COMMENT ‘商品价格’,
client_name varchar(50) DEFAULT NULL COMMENT ‘客户姓名’,
client_gender enum(‘男’,’女’) DEFAULT NULL COMMENT ‘客户性别’,
client_address varchar(200) DEFAULT NULL COMMENT ‘客户地址’,
delivery_date date DEFAULT NULL COMMENT ‘送货日期’,
install_date date DEFAULT NULL COMMENT ‘安装日期’
）；
/
插入数据
/
insert into order value(
-> ‘d9807764402298340’,
-> ‘好心情’,
-> ‘66666.88’,
-> ‘文老师’,
-> ‘男’,
-> ‘北京市朝阳区学区大别墅’,
-> ‘2021/3/26’,
-> ‘2021/3/27’
-> );
insert into order value(
-> ‘e2384975910746382’,
-> ‘好身体’,
-> ‘88888.66’,
-> ‘丑老师’,
-> ‘男’,
-> ‘北京市西城区学区大别墅’,
-> ‘2021/3/27’,
-> ‘2021/3/28’
-> );
insert into order value(
-> ‘r2384975910957382’,
-> ‘好事业’,
-> ‘77777.88’,
-> ‘倪老师’,
-> ‘女’,
-> ‘济南市大明湖畔’,
-> ‘2021/3/27’,
-> ‘2021/3/28’
-> );
/
输出订单表
*/