SQL utile

1. 1. Select n years before

select CONCAT(
              "http://photo.gabory.fr/picture.php?/",
              id,
              "/category/",
              storage_category_id
             ),
       TIMESTAMPDIFF(YEAR, date_creation, now())
FROM images
WHERE MONTH(date_creation) = MONTH(now())
AND
DAY(date_creation) = DAY(now())
LIMIT 4;

1. 1. Generate series cartesian select

select order_id, item_id from generate_series(1, 10) as order_id, generate_series(1, 3) as item_id;

Edit History Backlinks