SAS BLOG

Kalendarz w MySql

Thursday, March 4th, 2010 | Uncategorized | 1 Comment

create table firstday (data date);
insert into firstday values (’2010-02-20′);

DROP TABLE jednosci;
CREATE TABLE jednosci (jednosci int);
INSERT INTO jednosci VALUES (1);
INSERT INTO jednosci VALUES (2);
INSERT INTO jednosci VALUES (3);
INSERT INTO jednosci VALUES (4);
INSERT INTO jednosci VALUES (5);
INSERT INTO jednosci VALUES (6);
INSERT INTO jednosci VALUES (7);
INSERT INTO jednosci VALUES (8);
INSERT INTO jednosci VALUES (9);
INSERT INTO jednosci VALUES (10);

drop table dziesiatki;
CREATE TABLE dziesiatki (dziesiatki int);
INSERT INTO dziesiatki VALUES (0);
INSERT INTO dziesiatki VALUES (10);
INSERT INTO dziesiatki VALUES (20);
INSERT INTO dziesiatki VALUES (30);
INSERT INTO dziesiatki VALUES (40);
INSERT INTO dziesiatki VALUES (50);
INSERT INTO dziesiatki VALUES (60);
INSERT INTO dziesiatki VALUES (70);
INSERT INTO dziesiatki VALUES (80);
INSERT INTO dziesiatki VALUES (90);

drop table setki;
CREATE TABLE setki (setki int);
INSERT INTO setki VALUES (00);
INSERT INTO setki VALUES (100);
INSERT INTO setki VALUES (200);
INSERT INTO setki VALUES (300);
INSERT INTO setki VALUES (400);
INSERT INTO setki VALUES (500);
INSERT INTO setki VALUES (600);
INSERT INTO setki VALUES (700);
INSERT INTO setki VALUES (800);
INSERT INTO setki VALUES (900);

DROP TABLE tysiac;
CREATE TABLE tysiac AS ( SELECT jednosci+dziesiatki+setki AS x FROM jednosci CROSS JOIN dziesiatki cross join setki ORDER BY x);
select * from tysiac

create table calendar as( select
ADDDATE(data, x) as data from
firstday a cross join
tysiac b);