mysql按周统计_MySQL按周统计 WEEK 实例

最新推荐文章于 2024-02-03 21:40:50 发布

耗奇心

最新推荐文章于 2024-02-03 21:40:50 发布

阅读量139

点赞数

文章标签： mysql按周统计

本文链接：https://blog.csdn.net/weixin_36249942/article/details/113336717

版权

--创建数据样例表

CREATE TABLE `day_weight_tb` (

`day_date` varchar(16) DEFAULT NULL,

`in_weight` varchar(64) DEFAULT NULL,

`out_weight` varchar(64) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;--插入样例数据

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2018-03-10‘, ‘18.84‘, ‘74.14‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-21‘, ‘17.69‘, ‘25.97‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-02-01‘, ‘16.48‘, ‘10.0‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-29‘, ‘10.9‘, ‘74.12‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-02-13‘, ‘15.25‘, ‘16.62‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-12‘, ‘19.21‘, ‘95.42‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-02-14‘, ‘26.38‘, ‘20.59‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-24‘, ‘15.99‘, ‘16.823‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-13‘, ‘94.846‘, ‘56.256‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-03-03‘, ‘15.63‘, ‘12.128‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-03-12‘, ‘14.282‘, ‘24.046‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-16‘, ‘14.045‘, ‘11.73‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-03-08‘, ‘23.41‘, ‘23.441‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-31‘, ‘11.177‘, ‘4332.26‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-01-23‘, ‘11.8‘, ‘17104.49‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-03-17‘, ‘17.95‘, ‘13.81‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-03-01‘, ‘19.23‘, ‘20.43‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-02-05‘, ‘21.55‘, ‘51.0‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-02-27‘, ‘13.003‘, ‘23.32‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-03-11‘, ‘16.44‘, ‘24.44‘);

INSERT INTO `day_weight_tb` (`day_date`, `in_weight`, `out_weight`) VALUES (‘2019-02-28‘, ‘16.48‘, ‘23.4‘);

关注