Treceți la conținutul principal

some crud operations for life

 INSERT INTO life_in_time_and_space

         VALUES (your_heart, your_space);
INSERT INTO life_in_time_and_space
        VALUES (my_heart, my_space);

SELECT you, time, space
   FROM life
WHERE
id=idea_for_life_in_time_and_space
UNION ALL
SELECT me, time, space
   FROM life
WHERE
id=idea_for_life_in_time_and_space;

SELECT life.*,
               you.heart, you.thoughts,
               me.heart, me.thougths
  FROM life
INNER JOIN life_in_time_and_space you ON life.id=you.idea_for_life_in_time_and_space
INNER JOIN life_in_time_and_space me ON life.id=me.idea_for_life_in_time_and_space;

UPDATE life
       SET
us=idea_of_us_in_time_and_space, time=sysdate_with_no_special_formatting, space=somewhere_in_the_Whole_Wide_World_over_the_rainbow_sometimes
WHERE id=idea_of_us;

DELETE
   FROM life
WHERE us=not_in_the_same_time_and_space;

Comentarii

Postări populare de pe acest blog

i`m very old and very wrong..

  1. De ce ai accepta acest joc?   2. Vintage or new age?   3. De ce ai croit blogul sau un cont pe facebook?   4. In ce limba gandesti si in care ti.ai dori sa scrii?   5. What do you want to be when you grow up?   6. Unde ar merita sa petreci tot restul vietii si unde ai putea sa ratacesti o eternitate?   7. Este e=mc2 o afirmatie sau o dorinta?   8. Carte vs. film sau teatru!   9. Ultimul regret! 10. Ce jucarie ratacita in copilarie ti.ar lipsi acum daca te.ai gandi la asta fie doar prin faptul ca am intrebat? 11. Ce ai sa faci de ziua ta?