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