工作日表做成

最新推荐文章于 2024-07-03 03:36:35 发布
最新推荐文章于 2024-07-03 03:36:35 发布
阅读量191 收藏
点赞数
分类专栏： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/pcjk8866/article/details/104706298
版权

1、创建日期表
CREATE TABLE t_date (
v_date VARCHAR(10) NOT NULL,
PRIMARY KEY (v_date)
)
COLLATE=‘utf8_general_ci’
ENGINE=InnoDB
;

2、更新日期数据到表中
insert ignore t_date select DATE_ADD(current_date,INTERVAL 1 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 2 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 3 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 4 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 5 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 6 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 7 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 8 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 9 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 10 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 11 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 12 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 13 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 14 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 15 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 16 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 17 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 18 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 19 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 20 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 21 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 22 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 23 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 24 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 25 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 26 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 27 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 28 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 29 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 30 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 31 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 32 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 33 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 34 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 35 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 36 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 37 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 38 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 39 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 40 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 41 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 42 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 43 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 44 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 45 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 46 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 47 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 48 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 49 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 50 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 51 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 52 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 53 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 54 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 55 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 56 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 57 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 58 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 59 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 60 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 61 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 62 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 63 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 64 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 65 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 66 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 67 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 68 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 69 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 70 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 71 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 72 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 73 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 74 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 75 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 76 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 77 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 78 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 79 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 80 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 81 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 82 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 83 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 84 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 85 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 86 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 87 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 88 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 89 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 90 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 91 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 92 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 93 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 94 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 95 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 96 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 97 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 98 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 99 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 100 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 101 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 102 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 103 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 104 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 105 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 106 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 107 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 108 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 109 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 110 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 111 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 112 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 113 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 114 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 115 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 116 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 117 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 118 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 119 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 120 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 121 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 122 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 123 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 124 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 125 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 126 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 127 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 128 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 129 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 130 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 131 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 132 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 133 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 134 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 135 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 136 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 137 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 138 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 139 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 140 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 141 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 142 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 143 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 144 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 145 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 146 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 147 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 148 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 149 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 150 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 151 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 152 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 153 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 154 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 155 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 156 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 157 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 158 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 159 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 160 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 161 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 162 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 163 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 164 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 165 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 166 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 167 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 168 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 169 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 170 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 171 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 172 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 173 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 174 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 175 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 176 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 177 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 178 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 179 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 180 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 181 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 182 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 183 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 184 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 185 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 186 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 187 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 188 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 189 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 190 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 191 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 192 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 193 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 194 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 195 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 196 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 197 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 198 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 199 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 200 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 201 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 202 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 203 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 204 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 205 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 206 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 207 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 208 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 209 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 210 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 211 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 212 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 213 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 214 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 215 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 216 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 217 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 218 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 219 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 220 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 221 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 222 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 223 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 224 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 225 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 226 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 227 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 228 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 229 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 230 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 231 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 232 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 233 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 234 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 235 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 236 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 237 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 238 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 239 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 240 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 241 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 242 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 243 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 244 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 245 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 246 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 247 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 248 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 249 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 250 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 251 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 252 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 253 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 254 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 255 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 256 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 257 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 258 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 259 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 260 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 261 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 262 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 263 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 264 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 265 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 266 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 267 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 268 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 269 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 270 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 271 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 272 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 273 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 274 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 275 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 276 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 277 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 278 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 279 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 280 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 281 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 282 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 283 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 284 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 285 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 286 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 287 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 288 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 289 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 290 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 291 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 292 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 293 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 294 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 295 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 296 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 297 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 298 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 299 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 300 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 301 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 302 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 303 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 304 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 305 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 306 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 307 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 308 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 309 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 310 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 311 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 312 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 313 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 314 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 315 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 316 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 317 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 318 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 319 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 320 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 321 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 322 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 323 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 324 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 325 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 326 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 327 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 328 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 329 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 330 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 331 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 332 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 333 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 334 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 335 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 336 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 337 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 338 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 339 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 340 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 341 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 342 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 343 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 344 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 345 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 346 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 347 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 348 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 349 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 350 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 351 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 352 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 353 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 354 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 355 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 356 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 357 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 358 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 359 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 360 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 361 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 362 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 363 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 364 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 365 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 366 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 367 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 368 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 369 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 370 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 371 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 372 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 373 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 374 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 375 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 376 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 377 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 378 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 379 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 380 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 381 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 382 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 383 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 384 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 385 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 386 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 387 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 388 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 389 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 390 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 391 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 392 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 393 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 394 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 395 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 396 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 397 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 398 DAY) from dual;
insert ignore t_date select DATE_ADD(current_date,INTERVAL 399 DAY) from dual;

3、创建日期平日周末表
CREATE TABLE t_date_info (
date_var VARCHAR(10) NOT NULL COMMENT ‘日期’,
year_var VARCHAR(4) NOT NULL COMMENT ‘年’,
month_var VARCHAR(7) NOT NULL COMMENT ‘年月’,
week_int TINYINT(4) NOT NULL COMMENT ‘星期（1-周日，2-周一，3-周二…，7-，周六）’,
week_flag TINYINT(4) NOT NULL COMMENT ‘周末标识，1-周六周日，0-周一~周五’,
is_rest_date CHAR(1) NULL DEFAULT NULL COMMENT ‘1-法定调休休息日，2-法定调休上班日’,
is_work CHAR(1) NULL DEFAULT NULL COMMENT ‘1-上班日，其它-休息日’,
PRIMARY KEY (date_var)
)
COLLATE=‘utf8_general_ci’
ENGINE=InnoDB
;

4、更新周末标识
INSERT ignore t_date_info (year_var, month_var,date_var, week_int, week_flag)
select substring(v_date,1,4),substring(v_date,1,7),v_date,v_week,if((v_week=7 or v_week=1),1,0) from (select DAYOFWEEK(v_date) v_week,v_date from t_date) t

5、周一到周五休息日更新
// call splitString(‘2017-01-02,2017-01-27,2017-01-30,2017-01-31,2017-02-01,2017-02-02,2017-04-03,2017-04-04,2017-05-01,2017-05-29,2017-05-30,2017-10-02,2017-10-03,2017-10-04,2017-10-05,2017-10-06’,’,’);

CREATE TABLE tmp_split (
val_ VARCHAR(50) NOT NULL,
PRIMARY KEY (val_)
)
ENGINE=InnoDB
;
insert ignore tmp_split values (‘2019-01-01’);
…

update
t_date_info t1,tmp_split t2
set
t1.is_rest_date=1
where
t1.date_var=t2.val_

select * from t_date_info where is_rest_date =1

6、周、六日上班更新
// call splitString(‘2017-01-22,2017-02-04,2017-04-01,2017-05-27,2017-09-30’,’,’);
CREATE TABLE tmp_split2 (
val_ VARCHAR(50) NOT NULL,
PRIMARY KEY (val_)
)
ENGINE=InnoDB
;
insert ignore tmp_split2 values (‘2019-01-01’);
…

update
t_date_info t1,tmp_split2 t2
set
t1.is_rest_date=2
where
t1.date_var=t2.val_

select * from t_date_info where is_rest_date =2

7、根据周一到周五休息日、周、六日上班日更新工作日
select * from t_date_info t1 where (t1.week_flag=0 and t1.is_rest_date is null) or t1.is_rest_date=2

update
t_date_info t1
set
t1.is_work=1
where
(t1.week_flag=0 and t1.is_rest_date is null) or t1.is_rest_date=2

8、创建每月工作天数表
CREATE TABLE t_month_work_days (
month_var VARCHAR(7) NOT NULL COMMENT ‘月份：2017-01’,
is_work CHAR(1) NOT NULL COMMENT ‘1-工作日，其它-休息日’,
days TINYINT(4) NULL DEFAULT NULL COMMENT ‘天数’,
PRIMARY KEY (month_var, is_work)
)
COMMENT=‘每月工作日天数表’
COLLATE=‘utf8_general_ci’
ENGINE=InnoDB
;

9、更新每月工作天数
INSERT ignore t_month_work_days (month_var, is_work, days)
select t1.month_var,t1.is_work,count(*) from t_date_info t1 group by t1.month_var,t1.is_work

carlos yue
关注
专栏目录
Matlab GUI编程技巧（九）：详解 uitable 函数显示表格及相关操作（创建表用户界面）
左手の明天的博客
05-25 1万+
🔗运行环境：Matlab 🚩撰写作者：左手の明天 🥇精选专栏：《python》 🔥推荐专栏：《算法研究》 💗 大家好🤗🤗🤗，我是左手の明天！💗 📆 最近更新：2022 年 5 月 25 日，左手の明天的第246篇原创博客 📚更新于专栏：Matlab GUI编程技巧 目录 🚩创建表用户界面组件：uitable ⭐️语法 ⭐️ColumnWidth-表列的宽度 ⭐️Position-表的位置和大小 ⭐️Units-测量单位 ⭐️显示表数组数据 ...
数仓(七)：全量、 增量、缓慢变化维、拉链表
.
11-13 5490
一、解决增量导入由于数据修改导致数据重复问题 方案一：全量更新 目标表只保留最新的一份，比如我们每天用sqoop抽取最新的一份全量数据到hive 全量表 全量表没有分区，表中的数据是前一天的所有数据，比如说今天是24号，那么全量表里面拥有的数据是23号的所有数据，每次往全量表里面写数据都会覆盖之前的数据，所以全量表不能记录历史的数据情况，只有截止到当前最新的、全量的数据。 方式：每天drop掉前一天的数据，重新抽一份最新的。 优点：节省空间，一些普通的使用也很方便，不用在选择表的时候加一个时间分
工作日的数据库表，倒入即可
01-05
SQL计算两个日期之间的工作日天数，去除法定节假日和周末
工作日数据库表
01-05
SQL计算两个日期之间的工作日天数，去除法定节假日和周末
mysql查询距离当前时间八天
最新发布
weixin_36325338的博客
07-03 65
如何实现“mysql查询距离当前时间八天” 整体流程 下面是实现“mysql查询距离当前时间八天”的步骤表格： 步骤 描述 1 获取当前时间 2 计算八天前的时间 3 查询数据库中时间字段在这个时间范围内的数据 具体步骤与代码示例 步骤1：获取当前时间 在mysql中，可以使用NOW()函数获取...
2020年工作日数据表。
11-22
2020年全年详细工作日、周末、节假日数据表（SQL）下载，包含excel表，以及导入数据库sql，包含建表语句,大家下载可直接导入数据库
2019 年全年详细工作日、周末、节假日数据表（SQL）
01-09
数据表包含2019年每个日期对应的节假日类型（工作日，节假日，周末），导入即可
MySql语法记录
课题研究小组
11-24 630
示例表结构以及数据 1、LEFT JOIN：左连接，从左表 (table_name1) 那里返回所有的行，即使在右表 (table_name2) 中没有匹配的行 例1：查询出user_info表中所有列，以及user_info_new表中对应用户的联系电话（如果有的话）。 SELECT ui.*,uin.user_tel FROM user_info ui LEFT JOIN user_info_new uin ON ui.user_id = uin.user_id ...
工作日节假日调休日休息日的判断API-holiday
qq_29545781的博客
04-15 2554
工作日节假日调休日休息日的判断API-holiday 1. 背景 从2019年开始接一个需求，调单设置超期反馈时间T+2及邮件发送时间T+1都需要排除休息日；之前一个接口http://api.goseek.cn/ 是可以获取到全年每一天的性质四种<后续介绍>；但是2020年需要更新数据了，这个页面就打不开了，开始想法自己实现，并想做成静态工具类。 2. 设计思路 若没有节假日，...
【实验技术笔记】利用重组载体做基因过表达（pCDH载体）
abdslfwoeugp
06-19 2万+
1. 构建基因过表达载体 1.1 设计 PCR 引物 1.2 PCR 扩增目的基因 1.3 酶切载体和 PCR 产物 1.4 电泳并回收酶切产物 1.5 连接 1.6 转化 1.7 挑选阳性克隆并鉴定 2. 转染 3. 检测过表达效果 附表：常用酶切位点保护碱基............
李想：“做正确的事，不做容易的事”
科技D人生
03-07 3609
分享一个大神的人工智能教程。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到人工智能的队伍中来！点击浏览教程 李想，汽车之家网站创始人，前任汽车之家总裁。李想是80后的典型代表，1998年还在上高中的李想就开始做个人网站，2000年注册泡泡网并开始运营，仅凭借着自己对IT产品的一腔热爱和滚雪球式的资本积累，高中学历的李想让泡泡网在中国互联网行业中独树一帜。 2005年，李想带领团队从IT产...
mysql when、DAYOFWEEK、DATE_SUB、INTERVAL用法
qq_28865843的博客
05-06 423
运行结果为传入的5.9日是周二，查询到的是两个工作日前的数据为五月五号周五。比如周一查询周四的日期、周五查询周三的日期、周日查询周四的日期等等。查询日期为两个工作日前的日期（忽略节假日，只计算周六日）
mysql 加三天_MySQL添加几天到日期？
weixin_33410492的博客
02-27 1528
要将日期添加到日期，可以使用MySQL中的DATE_ADD()函数。语法如下，以在日期中添加天数-INSERTINTOyourTableNameVALUES(DATE_ADD(now(),intervalnday));在以上语法中，您可以使用curdate()代替now()。该curdate()会只存储日期，同时now()将存储日期和时间。这是两个功能的演示。为了理解上述语法，让我们创建...
MySQL （六）函数(字符串、数值、日期、流程空值)、窗口函数（聚合、排名、取值）
boxiansi的博客
03-12 375
when条件中用到列名，用第二种；when条件中用不到列名，用第一种。（个人理解，有误戳我改正）
mysql生成最近24小时整点&最近30天&最近12个月时间临时表
pscool的博客
01-22 1011
在统计的时候需要按时间来展示，但是数据的时间不一定是连续的，那就需要在代码里面生成连续的时间，然后按时间匹配到对应的数据，这样比较麻烦，可以在sql中使用连接查询与会话变量生成连续的时间，做成1个临时表，然后再来连接上数据表。
Mysql中日期比较大小的方法
Mynah886的博客
07-07 1万+
假如有个表`commodity`有个字段add_time,它的数据类型为datetime,有人可能会这样写sql：                     select * from product where add_time = '2013-01-12';   这种语句，如果你存储的格式是YY-mm-dd这样，那么OK， 如果你存储的格式是：2018-01-12 23:23:56 这种就悲剧...
INTERVAL 用法
热门推荐
Oracle
04-14 3万+
oracle 10g以后，出现 INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND Interval year(precision) to month   precision是这个时限的年部分所要求的最大位数。 默认为2，范围为0~9 Interval day(d_precision) to second(s_precision)   d_p
interval day to second和interval…
babymouse1212的博客
05-02 1866
在9i 版本以前，Oracle 没有内置的方式来记录时间的流逝。DATE型数据用来记录单独的时间点；但是要表达一个时间量（也就是一个间隔），数据库的设计者就必须把时间间隔转换成原始单位秒，然后用一个NUMBER列来保存它。 虽然NUMBER这个数据类型可以以秒为单位准确地表示时间，但是它使得时间的计算变得很困难。比如，60秒是1分钟，60分钟是1个小时，24个小时等于1天——这些数字在以十进制
日期偏移INTERVAL * DAY
MISTERFG的博客
09-07 8103
select DATE_FORMAT(date_sub(now(), INTERVAL 1 DAY),'%Y-%m-%d 00:00:00');
IT日语基础语法关键表达
"IT日语基本语法文档涵盖了对日外包工作中常用的日语语法，包括了因为…所以、客观存在、表示原因等13种句型，旨在帮助IT专业人士更好地理解和运用日语进行技术交流。" 在IT领域与日本进行外包合作时，掌握一定的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值