| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> that would return nothing though
<1> er
<0> how can a field be of 2 different values?
<1> the values are attributes of varying name... so we have a key in one field, and the attriute in another
<1> i want to retrieve a key with multiple specific attributes (which are stored across multiple rows)
<1> ok, better explanation. if i have a table for group membership and have group:member, and want to figure out the name of the groups that contain a specific set of members... how do i make that query?
<0> hm okay i think i get it
<0> for example where you would like to know in which group you can find members 1 AND 2 AND 8 AND 14
<1> yeah
<0> that is something i never done, gimme a sec
<1> but it's not a query on a singular row, so i'm not sure how i can do that
<1> thankyou kindly =]
<0> okay i don'T know exactly and my head does not answer my calling...
<0> i think you could work with a Group By groupname
<1> i never quite got 'group by' and only had to use it once... promptly forgetting it
<1> heh
<1> i'll look it up again <_<
<0> maybe something like GROUP BY GroupName HAVING something
<0> thaT's what you use to count reows for a value in a field for make aggregate functions, maybe there's one about that
<0> OH!
<1> oh?
<0> maybe got an idea, maybe not the ebst one but could do... SELECT GroupName FROM (SELECT GroupName FROM membership as M1 INNER JOIN membership as m2 on m1.groupename = m2.groupename WHERE m1.MemberID = 6 AND m2.MemberID = 18)
<0> hm...
<0> changed my idea while writing it, you don't need the first SELECT Groupname etc... only the one in parenthesis
<1> 0.o
<0> that would return all groups where there is Members 6 AND 18
<1> nice
<1> i think i got that
<1> temporary tables putting stuff on a single row
<0> hm it's not a temporary table, it's simply an inner join but yeah it will put stuff all on the same row
<1> thanks again
<1> that is -exactly- what i needed
<1> :)
<1> take care
<0> good, as i said...
<0> ...
<2> how long would it take +/- to select a id like WHERE sitename="http://...blah"; with 40 000 sites and without an index?
<2> am i talking about minuts?
<3> HS^: you con't ***ign a number to that
<3> depends on how fast of hardware, does all the db fit in RAM, how many sinultainous connections
<2> no i mean like SELECT siteid FROM table WHERE sitename="http://www.google.nl";
<2> hardware and memory s not that good..
<2> id say normal, but am i talking about minuts here?
<2> or even 30 seconds
<3> no I mean differernt hardware config's and system loads will give different numbers
<3> one server might do it in 30 sec, same server with 10,000 people hitting it might takes minutes
<2> this is query executed on a db every.....olike 2 seconds in a java program
<3> you cna't just give a number to a query
<2> but the program runs out of memory. now i jst thought about this, that maybe because its not indexed
<2> ||cw but its not a thing of a couple seconds?
<2> its not even a server, just a workstation
<3> fine. it'll take 42. pick a unit, doens't matter. it'll take 42.
<2> ok :>
<3> your question cannot be reliably answered, deal with it.
<2> i know that, but you can tell very broad if its a questoin of 2 miliseconds or 1 minut. seeing the db has to go through all urls
<3> and I explained why, if you don't understand it, then i don't know what. I cna't even comprehend
<3> how long does it take to open a 4 meg word doc?
<3> in seconds?
<2> probably 10 on new workstation
<3> 2 seconds? what about on a 486 with 16Meg ram?
<2> well system i use is 1 gig memory pentium 4
<3> what if it's a terminal server and 100 people are trying to open it at once, still 10 seconds?
<2> one connection.
<3> what if I open it, close it, and open again?
<2> one connection.
<3> 10 then 5 because it's cached?
<3> what if I have mp3's playing at the same time
<2> lol
<3> and a virus scanner ruuning
<2> ok ok i get your point
<3> see, you can't put an acurate time on it
<4> how can I test if a microsoft sql 2005 installation on windows small biz server 2003 is functional? (complete db noob, installing it for a certain app but it is unable to connect for some reason)
<5> Is there no statement for "IN ALL" in sql?
<3> gursikh: use the management studio
<3> tezem: in all what?
<5> ||cw: no I just realized that my query will not work at all.
<3> IN is used to limit a field to a list of values, like WHERE f1 IN(1,2,5), which is like WHERE f1=1 or f1=2 or f1=5
<3> in that context, IN ALL would be the same as not having a condition at all
<5> eventually you could help me with the query? It's a mess!
<3> post it on a pastebin, i'm in the middle of a couple thigns though
Return to
#sql
or
Go to some related
logs:
Broadcom HT1000 sarge
usbutils fedora 5 yum
#asm
#suse
dotdeb threadsafe
normal packing shader
kubuntu operon ram
#linux
#math
function CountString
|
|