#mysql - Fri 9 Mar 2007 between 00:05 and 01:18

NY Lost Funds



Tarantulafudgehey guys
is there a way to query a single column worth of data and have duplicates singled out?
like if a column has two sets of the same data, just print it once in the results
_syphilis_SELECT DISTINCT
Tarantulafudgesweet thanks _syphilis_
chadmaynardbed
the_wenchAre you making a suggestion at meeeee!!! ooo go on then, behind the bike shed in five minutes
ToeBeeerr
hot irc bot lovin'?
chadmaynardbotsnack
the_wenchooooh let me bend over and lift my skirt for that
chadmaynardtopoff
top off
the_wenchwww.archivist.info/thewench
Tarantulafudgeis it possible to join tables with identical column names?
chadmaynardyes
TarantulafudgeI'm new to joins so bear with me
I need to query a table and join two other tables which have names attatched to a common index
chadmaynardSELECT `tablea`.`id`, `tableb`.`id` FROM `tablea` JOIN `tableb` ON (`tablea`.`id` = `tableb`.`id`);
just use table.column syntax
Tarantulafudgeokay
chadmaynardunderstand?
Tarantulafudgeyea makes sense
chadmaynardyou can alias too
Tarantulafudgenow how can I use mutple joins like that
chadmaynardselect foo as bar;
fatpeltevening all. i'm trying to see if my server is going to roll properly on the 11th (DST). is there any way to test this via sql ?
actionfatpelt is on 4.1.22
fatpeltis on 4.1.22
chadmaynardTarantulafudge: you'll have to be more specific if you'd like me to answer that
Tarantulafudgegtg, thanks tho
chadmaynardbye!
dst
actionfatpelt is re-reading http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html
fatpeltis re-reading http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html
for about the 4th time
chadmaynardyou want to test the time change?
fatpeltyeah
kimseongfatpelt: http://sheeri.net/archives/188
fatpeltkimseong: PERFECT!
chadmaynard!wench learn DST is http://sheeri.net/archives/188
the_wenchI have learnt DST is http://sheeri.net/archives/188

Page: 2 9 16 23 30 37 44 51 58 

IrcArchive

NY Lost Funds