b3ta.com board
You are not logged in. Login or Signup
Home » Messageboard » XXX » Message 878406 (Thread)

# I wish I knew how to use this propetly
It allows you to use SQL to query the sky above your head. Is that the nerdiest thing ever?

www.skyquery.net/SkyQuery.aspx
(I helped save b3ta! rob, Wed 5 Mar 2003, 11:21, archived)
# or it
allows you to use SQL to query the nasa space pics database..
(I helped save b3ta! munkt0n, Wed 5 Mar 2003, 11:23, archived)
# i think it just might be.
blimey.
(I helped save b3ta! wingphil, Wed 5 Mar 2003, 11:25, archived)
# But
what would you ask it?
(I helped save b3ta! GR33DY, Wed 5 Mar 2003, 11:26, archived)
# Daddy or Chips ?
silly !
(I helped save b3ta! FlanFlinger 🥧, Wed 5 Mar 2003, 11:27, archived)
# you mean
select * from sky where ANSWER like 'daddy' or ANSWER like 'chips';
(I helped save b3ta! LP, Wed 5 Mar 2003, 11:32, archived)
# I tried "show me the planets where the aliens live"
but it didn't work.
(I helped save b3ta! rob, Wed 5 Mar 2003, 11:28, archived)
# got the syntax wrong
try

SELECT * FROM planets WHERE aliens_live = true;
(I helped save b3ta! munkt0n, Wed 5 Mar 2003, 11:29, archived)
# Aha
I see your mistake, it should have looked like this.

SELECT Sky.Where_The_Aliens_Live,
FROM Sky
GROUP BY Sky.Where_The_Aliens_Live,
HAVING (Sky.Do_Aliens_Live_Here=True);
(I helped save b3ta! GR33DY, Wed 5 Mar 2003, 11:32, archived)
# Send it
to Patrick Moore as a late birthday present!
(Divvy, Wed 5 Mar 2003, 11:31, archived)
# damn that is nerdy
i love it

woo to nerds
(ozric99, Wed 5 Mar 2003, 11:51, archived)