| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> How about just aliasing it in the first place?
<0> I need more RAM...
<1> will: again, thank you very very much, i didn't even know "AS" was possible
<0> Don't be too thankful to me. It overinflates my ego.
<2> hello all, back again
<0> oh no
<2> hehe
<0> :)
<2> just a quick question this time
<2> is there a way to join a table on itself?
<0> Wow, that was quick.
<0> Yes
<0> Called a self join.
<2> oooh cool
<0> FROM table AS a LEFT JOIN table AS b ON a.id = b.other_id
<3> will's just a bot anyway
<2> lol
<2> ooooh that looks handy
<4> !man self join
<5> Nothing found.
<6> tempest1 -- I dont think what you said will work
<6> If I have table w columns ItemId, Name, Date, Time
<6> and I want new table, where the values for those fields become referenced by ItemId, Value of name field, and then actual value, i think this is more complex than what you said
<6> since I am compressing data from a large table, which has lets say 10 columns, into a table that only has 3 columns, itemId, fieldId, and value
<0> huh?
<4> night y'all
<0> We're goin hav sum fun tonight
<2> bah, I don't think a join's gonna work either >.<
<7> perhaps if you said what you were trying to do...
<2> something tells me this should be really simple but i'm making it more complicated than it needs to be....
<0> What do you want?
<2> hmm
<2> well, here's what tempest1 suggested
<2> SELECT FKuser FROM v1_user_experience WHERE ( FKsoftware =10 AND FKexperienceLevel >=5 ) OR ( FKsoftware =14 AND FKexperienceLevel >=2 )
<2> and that works, sorta
<0> How does it not work?
<2> but using an OR means it gets people that fit either criteria
<2> using and tries to get ones that fit both
<2> but i get zero results
<2> even though there are rows that match both
<0> You're screwed.
<2> lol
<2> i could probably do it with four seperate queries and then use php to sort out the ensuing mess but i'd rather just do one query that gets the right results from the start
<7> well what is the information that you are actually trying to retrieve ?
<0> You could just give up.
<7> heh :P
<2> i can't just give up, i'm getting paid to make it work >.<
<0> That's where you are wrong.
<0> Leave the country.
<0> Now.
<0> Don't tell anyone where you're going. Not even your wife.
<2> here's the table structure http://www2.slothworks.com/tablestructure.jpg
<2> here's the search form http://www2.slothworks.com/search.jpg
<2> will, I can take my son right?
<2> :p
<2> the wife i won't mind leaving behind
<2> lol
<0> Only if he's under 2.
<2> damn
<0> lol
<2> he is 2
<2> :p
<7> oh i don't know - you can still sell them when they are older
<0> Too old.
<0> Must cut off loose ends.
<2> lol
<2> and what would I do while out of the country? drift aimlessly? I think I'd rather just find a way to make this work and get paid lol
<2> :p
<0> Live in a cave and eat bats.
<7> Kris: it would be much neater if you had another table with the required experience level for each piece of software - then you could just use a join
<2> lol
<2> i'd die if I couldn't play with 3dsmax on my spare time though >.<
<0> It's after 10PM. So seriousness is out.
<0> Geek...
<2> lol
<2> yup
<0> Maybe you need a subquery.
<2> subquery?
<7> yup that might work too
<0> I shouldn't be talking about geeks.
<2> what is a subquery?
<2> lol
<0> !man subquery
<5> (Subquery Syntax) : http://dev.mysql.com/doc/mysql/en/Subqueries.html
<7> could be worse - at least it is not gentoo
<0> haha
<2> no one who hangs out in a mysql irc channel should talk about geeks methinks
<2> :p
<0> :P
<0> What if I got paid to hang out in #mysql?
<2> hmmmm that would make a difference
<8> that's a big iff
<2> I guess you coud say i'm getting paid to hang out in #mysql insofar as I'm getting paid to figure out why the client's search engine isn't working
<0> Celeron 366 w/96MB of RAM with FC5...
<7> LOL i see what you mean by needing more ram
<0> What were the requirements again?
<0> andrewbryson, Actually, that request was for my "main" comp.
<0> Only 1GB.
<7> oh that ****s
<0> I want to run VMware.
<7> 1GB is barely enough for half a dozen virtual machines
<0> Not bad when all I do is code.
<2> ok here goes a subquery
<0> andrewbryson, Half a dozen??? No way. That is barely enough for ONE VM. I'm running WinXP MCE !
<7> if you are using it from a command shell it will be fine
<7> if you want X it could be slow :P
<7> :|
<7> seriously ? :|
<7> vmware at work gives me nightmares
<7> and i am sure that it is because it is running on windows
<7> i have no such problems at home
<0> I've ran VMware with Windows as the host. No problems.
<0> Just need RAM.
<2> My linux box is running ubuntu on a 500mhz p3 with 256mb ram *shrugs* does everything I need it to do
<2> ok here's the subquery and nothing came out of it
<2> SELECT FKuser FROM v1_user_experience WHERE 1 = (SELECT FKuser FROM v1_user_experience WHERE FKsoftware =10 AND FKexperienceLevel >=5 ) AND (SELECT FKuser FROM v1_user_experience WHERE FKsoftware =14 AND FKexperienceLevel >=2 )
<2> or is that not the right syntax...
<2> nevermind
<2> my bad
<2> bah
<2> no that should be kosher according to the documentation
<2> >.<
<2> What i'm asking it must not be what i think i'm asking it
<0> What are you asking for again?
<2> http://www2.slothworks.com/search.jpg
<0> Do I really have to look there...? :(
<2> I'm asking it to search the table for users that match the four software dropdowns
<2> lol
<0> I'm afraid I'm going to see naked pictures.
<2> no but i think better in pictures
<2> anyway
<7> right so you have a user database and you want to find all the users who have a suitable level of skill in a range of software packages ?
<2> yup
<2> client wants to be able to search by up to four software packages at once
<7> is it an and search or an or search ?
<2> and
<7> so it needs to return only users that have skills in all of the required packages ?
Return to
#mysql
or
Go to some related
logs:
#ldap
#perl
nvidia_drv.so unrecognized module typ
download kismet.fc5
#debian
lvm ext3 journal abort
inplace replace sed
getting a random character perl
#ubuntu
#math
|
|
