CREATE TABLE Data (d DATE, i INT);
INSERT INTO Data VALUES ('2017-02-01', 10), ('2017-02-05', 6),
('2017-02-05', 7), ('2017-02-07', 4);
DELIMITER $$
CREATE PROCEDURE all_those_days(IN start DATE, IN stop DATE)
BEGIN
DROP TEMPORARY TABLE IF EXISTS series;
CREATE TEMPORARY TABLE series (d DATE PRIMARY KEY) ENGINE = MEMORY;
WHILE start < stop DO
INSERT INTO series VALUE (start);
SELECT DATE_ADD(start, INTERVAL +1 DAY) INTO start;
END WHILE;
SELECT series.d, COALESCE(SUM(Data.i), 0) AS i
FROM series LEFT JOIN Data ON series.d = Data.d GROUP BY series.d;
END $$
DELIMITER ;
CALL all_those_days('2017-02-01', '2017-02-10');
int mask=0;
for i in 0..len(arr)-1{
int newmask = arr[i]&1==0 ? 0 :0x8000;//
arr[i]=(arr[i]>>1) | mask;
mask = newmask;
}
from itertools import permutations, product
def acronyms(x):
res = {x}
for digs in permutations(str(x)):
if digs[0] != '0': # число, если не ноль, не начинается с нуля
res.add(int(''.join(digs)))
return res
a, b, c = 54, 12, 75
zz = acronyms(c)
for x, y in product(acronyms(a), acronyms(b)):
if x + y in zz:
print("%d + %d = %d" % (x, y, x + y))