| |
| |
| |
|
Comments:
<0> evening
<1> i have this line select x,y from postcodes where (outcode in (select postcode from basicfeatures where carid=2)) UNION select x,y from postcodes where outcode='bn1';
<1> and i get +--------+--------+
<1> | x | y |
<1> +--------+--------+
<1> | 528500 | 105500 |
<1> | 531100 | 106100 |
<1> +--------+--------+
<1> can i do something to get the results in a way xa, ya , xb, yb and have it all in one row?
<0> http://www.youtube.com/w/Chad-getting-his-future-step-son-with-the-scary-maze?v=kKGxaol4qws&feature=Views&page=1&t=t&f=b
<0> lol
<0> K_F- awake?
<0> night poeple
<2> i installed mysql with slackware and it said STOPPING server from pid file
<2> then i tried downloading the new mysql and installing it but i couldn't run the config file because the old one is installed
<2> how do i uninstall the old version?
<3> bra artikel
<3> fint sagt av usa dr
<3> 85000 rwandier s kanske vi skickar lite stridisar
<3> whops
<3> wrong chan
<4> hehe
<4> what is the article in question?
<3> http://www.dn.se/DNet/jsp/polopoly.jsp?d=1159&a=520837&previousRenderType=3
<4> hmm, was scared for a moment that it was dagens nringsliv
<4> that would be the norwegian interprentation of DN
<3> ah no, i dont read norwegian news :)
<4> and DN is almost as tabloid as VG (Verdens Gang) and Dagbladet
<3> really? sounds like a serious paper
<3> i know verdens gang is a bit like our aftonbladet
<3> owned by schibstedt.. so perhaps its the same owner?
<4> and yeah, DN tries, and fails miserably to be Financial Times
<4> even the same color paper :)
<3> ah
<3> heh..
<4> we have finansavisen (hegnar.no)
<4> that is a good one
<3> well, we have dagens industri (di) which is a bit .. like that.. popular economics.. they do quite a good job though
<4> hmm, I'll have to look at that
<3> and theres always "veckans affrer" (veckansaffarer.se), n24.se and realtid.se
<4> http://news.ft.com still win the prize though
<3> the last one is quite funny, only internet and quite much attitude about what they do
<4> http://news.ft.com/siteservices/rss
<4> I'm a news junkie
<4> way too many RSS feeds in my aggregator
<3> yeah, i like news too
<3> im feed up with telegrams though
<3> no substance
<3> dn is almost the only paper worth looking for real articles in sweden
<3> everything else is verbatim copies from TT
<4> aftenposten.no is quite good here
<4> for "general news"
<4> hegnar.no for business news
<4> and you have some good magazines
<5> hi i have two tables, a table Addresses with a column user_id and a table Users with the column id. Now i want to select all user.id's that do not occur in the column user_id of the table addresses, can anyone help me out?
<4> seldon: outer join, is null , http://www.kfwebs.net/links/6 for SQL
<5> hmm
<5> could you help me out a bit more :)
<4> hmm, bouncy
<3> seldon, what K_F is trying to say i that you should atleast try to read the manual, and then ask a question that proves that you actually tried todo something about your problem yourself.
<3> "say _is_ that"
<6> hello .. i have a question ..
<4> don't they all
<4> shoot
<6> i have a table with 6 fields (int each(
<4> lucky you
<6> how can i make a select with all the distinct values in that table
<6> :)
<6> no .. not lucky
<4> mihaitza_: http://www.kfwebs.net/links/6 for SQL
<4> look into the, surprise,surprise, DISTINCT keyword
<6> well i know distinct
<6> but.. i want only one field
<6> like
<6> i jave 12, 123,23,23,23
<6> i jave 1332, 12321,22313,2123,223
<6> and i want just one field with all the distinct values
<4> <4> mihaitza_: http://www.kfwebs.net/links/6 for SQL <4> look into the, surprise,surprise, DISTINCT keyword
<6> ok. 10 mins
<6> i did not find any distinct tutorial
<6> so.. google time
<6> i was hoping for a quick answer
<6> bye
<4> lamer
<7> can't all be as super cool as you :-)
<4> eh
<7> K_F consider it 'reasnoble' to require cookies to be enabled for shooping cart to work?
<4> yes and no
<4> not when you can just use transparent SID
<4> as in sending the session ID in the querystring
<7> transparent SID uses cookies
<4> no
<7> then how are you definieng 'transparent'
<4> if cookies are not available you can have it do a file.php?SID=XXXXXXX
<7> thats not transparent
<4> and it can add it to form automatically
<4> neither is cookies if you look at the network traffic
<7> ugly, potentially security issues
<4> depends on the timeout
<4> and of course you use SSL
<7> excutive diecision cookies it is.
<8> hi
<8> i have a question
<7> shock.
<8> finally its okay :)
Return to
#mysql
or
Go to some related
logs:
mmo pacman
7.TOTI
#c++
katesplaground.com
certwatch debian
pskolog
#ubuntu
#AllNiteCafe
cache:8vAVJ_c9-RYJ:www.quotesdb.info/undernet/london/28Jan2006/27.html CC,NAMES,
#AllNiteCafe
|
|