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?

Este un miros acut de ceai pe alee

D e-as sti unde esti De-as fi unde stai Si pasii stingheri adunati pe alei Ar sti intamplarea te-adune sub tei. E trist orasul E trist fara tine, ploaia mea de mai. I miss you every day. I follow in your footsteps on some alleys from time to time. My heart is yours to keep. I'll keep your heart at a fair rate of exchange. Este un miros acut de ceai pe alee.