(1)先创建一张测试表:
1 CREATE TABLE `用户购买订单` ( 2 3 `购买时间` datetime(6) NULL DEFAULT NULL, 4 5 `用户` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, 6 7 `费用` decimal(20, 2) NULL DEFAULT NULL 8 9 ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
(2)往数据表填充数据:
1 INSERT INTO `用户购买订单` VALUES ('2019-04-16 00:00:00.000000', '张三', 100.00); 2 3 INSERT INTO `用户购买订单` VALUES ('2019-04-15 00:00:00.000000', '李四', 95.00); 4 5 INSERT INTO `用户购买订单` VALUES ('2019-04-14 00:00:00.000000', '张A', 85.00); 6 7 INSERT INTO `用户购买订单` VALUES ('2019-04-13 00:00:00.000000', '张B', 70.00); 8 9 INSERT INTO `用户购买订单` VALUES (