Posted: 05.08.2012 10:49 Post subject: mysql pitanje
Kako se koristi not exists, jer recimo ova dva upita po meni trebala bi vracati isti rezultat, ali prvi vraca npr. 5 redaka, a drugi 0. U čemu griješim
-> ovaj radi
SELECT id_cat FROM izbornik WHERE id_cat NOT IN ( SELECT id_cat FROM kategorija )
->ovaj ne radi onako kako bi trebalo
SELECT id_cat FROM izbornik WHERE NOT EXISTS (SELECT id_cat FROM kategorija)
-> ovaj ne radi onako kako bi trebalo
SELECT id_cat FROM izbornik WHERE NOT EXISTS (SELECT id_cat FROM kategorija WHERE izbornik.id_cat = kategorija.id_cat)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum