sillyql / tests / test-7.txt
test-7.txt
Raw
# simple test, duplicates
CREATE friends 5 string string bool int string name vibe is_cool distance town
DELETE FROM friends WHERE vibe = Funny
INSERT INTO friends 7 ROWS
Izzy Edgy true 1000 Ann_Arbor
Izzy Funny false 1000 Ann_Arbor
Sam Cool true 30 Ann_Arbor
Tyler Nice true 9000 Mt_Clemens
Tyler Mean false 400 Mt_clemens
Bri Fun false 100 Ann_Arbor
Jack Edgy true 1000 AnnArbor
DELETE FROM friends WHERE distance < 300
PRINT FROM friends 2 name vibe WHERE distance < 300
PRINT FROM friends 2 name vibe WHERE distance > 300
PRINT FROM friends 2 name vibe WHERE distance = 300
QUIT