历年双色球中奖号码从2003年到2023年 Excel数据 mysql数据库数据文件

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50731 Source Host : localhost:3306 Source Schema : yii2advanced Target Server Type : MySQL Target Server Version : 50731 File Encoding : 65001 Date: 24/07/2023 10:16:39 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for caipiao_log -- ---------------------------- DROP TABLE IF EXISTS `caipiao_log`; CREATE TABLE `caipiao_log` ( `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `kj_date` date NULL DEFAULT NULL COMMENT '开奖时间', `xq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '星期', `number1` int(11) NULL DEFAULT NULL COMMENT '第1个号码(红色)', `number2` int(11) NULL DEFAULT NULL COMMENT '第2个号码(红色)', `number3` int(11) NULL DEFAULT NULL COMMENT '第3个号码(红色)', `number4` int(11) NULL DEFAULT NULL COMMENT '第4个号码(红色)', `number5` int(11) NULL DEFAULT NULL COMMENT '第5个号码(红色)', `number6` int(11) NULL DEFAULT NULL COMMENT '第6个号码(红色)', `number7` int(11) NULL DEFAULT NULL COMMENT '第7个号码(蓝色)', `jsondata` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'json数据', `total_sales` int(11) NULL DEFAULT 0 COMMENT '总销售额', `jackpot` int(11) NULL DEFAULT 0 COMMENT '奖池', `prize1_num` int(11) NULL DEFAULT 0 COMMENT '一等奖注数', `prize1_money` int(11) NULL DEFAULT 0 COMMENT '一等奖奖金', `prize2_num` int(11) NULL DEFAULT 0 COMMENT '二等奖注数', `prize2_money` int(11) NULL DEFAULT 0 COMMENT '二等奖奖金', `prize3_num` int(11) NULL DEFAULT 0 COMMENT '三等奖注数', `prize3_money` int(11) NULL DEFAULT 0 COMMENT '三等奖奖金', `prize4_num` int(11) NULL DEFAULT 0 COMMENT '四等奖注数', `prize4_money` int(11) NULL DEFAULT 0 COMMENT '四等奖奖金', `prize5_num` int(11) NULL DEFAULT 0 COMMENT '五等奖注数', `prize5_money` int(11) NULL DEFAULT 0 COMMENT '五等奖奖金', `prize6_num` int(11) NULL DEFAULT 0 COMMENT '六等奖注数', `prize6_money` int(11) NULL DEFAULT 0 COMMENT '六等奖奖金', PRIMARY KEY (`code`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of caipiao_log -- ---------------------------- INSERT INTO `caipiao_log` VALUES ('2003001', '2003-02-23', '日', 10, 11, 12, 13, 26, 28, 11, '[10,11,12,13,26,28,11]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003002', '2003-02-27', '四', 4, 9, 19, 20, 21, 26, 12, '[4,9,19,20,21,26,12]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003003', '2003-03-02', '日', 1, 7, 10, 23, 28, 32, 16, '[1,7,10,23,28,32,16]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003004', '2003-03-06', '四', 4, 6, 7, 10, 13, 25, 3, '[4,6,7,10,13,25,3]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003005', '2003-03-09', '日', 4, 6, 15, 17, 30, 31, 16, '[4,6,15,17,30,31,16]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003006', '2003-03-13', '四', 1, 3, 10, 21, 26, 27, 6, '[1,3,10,21,26,27,6]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003007', '2003-03-16', '日', 1, 9, 19, 21, 23, 26, 7, '[1,9,19,21,23,26,7]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003008', '2003-03-20', '四', 5, 8, 9, 14, 17, 23, 8, '[5,8,9,14,17,23,8]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003009', '2003-03-23', '日', 5, 9, 18, 20, 22, 30, 9, '[5,9,18,20,22,30,9]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003010', '2003-03-27', '四', 1, 2, 8, 13, 17, 24, 13, '[1,2,8,13,17,24,13]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003011', '2003-03-30', '日', 4, 5, 11, 12, 30, 32, 15, '[4,5,11,12,30,32,15]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003012', '2003-04-03', '四', 2, 12, 16, 17, 27, 30, 12, '[2,12,16,17,27,30,12]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003013', '2003-04-06', '日', 8, 13, 17, 21, 23, 32, 12, '[8,13,17,21,23,32,12]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003014', '2003-04-10', '四', 3, 5, 7, 8, 21, 31, 2, '[3,5,7,8,21,31,2]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003015', '2003-04-13', '日', 4, 11, 19, 25, 26, 32, 13, '[4,11,19,25,26,32,13]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003016', '2003-04-17', '四', 11, 17, 28, 30, 31, 33, 6, '[11,17,28,30,31,33,6]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003017', '2003-04-20', '日', 5, 8, 18, 23, 25, 31, 6, '[5,8,18,23,25,31,6]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003018', '2003-04-24', '四', 5, 16, 19, 20, 25, 28, 13, '[5,16,19,20,25,28,13]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003019', '2003-04-27', '日', 4, 8, 12, 13, 16, 33, 9, '[4,8,12,13,16,33,9]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003020', '2003-05-01', '四', 7, 10, 25, 26, 27, 32, 4, '[7,10,25,26,27,32,4]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003021', '2003-05-04', '日', 14, 15, 18, 25, 26, 30, 1, '[14,15,18,25,26,30,1]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003022', '2003-05-08', '四', 2, 7, 11, 12, 14, 32, 8, '[2,7,11,12,14,32,8]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003023', '2003-05-11', '日', 1, 10, 20, 22, 26, 31, 2, '[1,10,20,22,26,31,2]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003024', '2003-05-15', '四', 2, 7, 15, 17, 22, 30, 14, '[2,7,15,17,22,30,14]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003025', '2003-05-18', '日', 1, 5, 11, 13, 14, 27, 12, '[1,5,11,13,14,27,12]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003026', '2003-05-22', '四', 8, 13, 15, 26, 29, 31, 16, '[8,13,15,26,29,31,16]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003027', '2003-05-25', '日', 1, 11, 14, 17, 27, 28, 15, '[1,11,14,17,27,28,15]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003028', '2003-05-29', '四', 6, 13, 16, 20, 28, 32, 7, '[6,13,16,20,28,32,7]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003029', '2003-06-01', '日', 2, 7, 15, 26, 29, 32, 10, '[2,7,15,26,29,32,10]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003030', '2003-06-05', '四', 2, 6, 13, 14, 23, 27, 7, '[2,6,13,14,23,27,7]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003031', '2003-06-08', '日', 11, 17, 20, 22, 28, 32, 1, '[11,17,20,22,28,32,1]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003032', '2003-06-12', '四', 4, 11, 25, 27, 29, 30, 13, '[4,11,25,27,29,30,13]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003033', '2003-06-15', '日', 1, 7, 14, 20, 27, 30, 10, '[1,7,14,20,27,30,10]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `caipiao_log` VALUES ('2003034', '2003-06-19', '四', 8, 13, 14, 16, 23, 25, 14, '[8,13,14,16,23,25,14]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);