Vyhledávání
Advanced insert and updates
Insert/update with possible preserving the other values when duplicate key:
INSERT INTO my_table (id, col1, col2)
VALUES (1,1,1), (2,2,3), (3,9,3), (4,10,12)
ON DUPLICATE KEY UPDATE col1=VALUES(col1), col2=VALUES(col2);
Dates a times
DATE_SUB(NOW() , INTERVAL 1 DAY)