Skip to main content

Sadržaj

https://db.fitness-central.eu/ - PMA queries

  • 2 - Neaktivna
  • 3 - Ističe

sql queries

select * from clanarina WHERE datum_isteka BETWEEN '2022-01-01 00:00:00' AND '2022-12-29 00:00:00' and status_id = 3;

UPDATE clanarina SET status_id=2 WHERE datum_isteka BETWEEN '2022-01-01 00:00:00' AND '2022-12-29 00:00:00' AND status_id = 3;

select * from clanarina WHERE datum_isteka BETWEEN '2023-01-01 00:00:00' AND '2023-12-29 00:00:00' and status_id = 3;

UPDATE clanarina SET status_id=2 WHERE datum_isteka BETWEEN '2023-01-01 00:00:00' AND '2023-12-29 00:00:00' AND status_id = 3;

select * from clanarina join paket on clanarina.paket_id=paket.id WHERE datum_pocetka BETWEEN '2024-01-01 00:00:00' AND '2024-12-29 00:00:00' and paket.id in (18,19,20)

// update set status_id=1 aktivna UPDATE clanarina JOIN paket ON clanarina.paket_id = paket.id SET clanarina.status_id = 1 WHERE clanarina.datum_pocetka BETWEEN '2024-01-01 00:00:00' AND '2024-12-29 00:00:00' AND paket.id IN (18, 19, 20);

-- Članarine kojima je datum isteka u narednih 5 dana SELECT * FROM clanarina WHERE datum_isteka BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 5 DAY);

SELECT * FROM clanarina WHERE DATE(datum_isteka) = CURDATE() AND clanarina.status_id != 2

UPDATE clanarina SET status_id = 2 WHERE DATE(datum_isteka) = CURDATE() AND status_id != 2;

Back to top