| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> hello, i have a question, i have a table that maps one userid to another entity, i need to get a distribution over the counts, basically:
<0> select userid, count(questionid) from qanswers group by userid;
<0> is there a way to make it emit a table that is the number of users with N answers?
<0> so if i have like the following tuples (1, 50) , (2, 35), (3, 10), (4, 35) -> i get > (50, 1), (35, 2), (10, 1)
<0> (i'm using mysql) :(
<1> bright, is this homework?
<2> SELECT cq, COUNT(cq) FROM (SELECT COUNT(questionid) cq FROM quanswers GROUP BY userid) GROUP BY cq;
<3> hi all
<3> I have a process that works with the sql server. The process name is sqldumper.exe and write a lot of files in the LOG directory. Is it a needed process or can I disable it?
<0> Jarett_: no i'm just really tired and at work late on a friday
<0> i got it done, i used a temp table
<0> upd: thank you though
<0> hmm i want to try that now
<0> ..
<1> not many people use "tuple" anywhere but in a cl***
<0> i was trying to be technical
<4> practical > technical
<0> well thanks for all your help!
<0> :D
<0> mysql> select cq, count(cq) from (select count(questionid) cq from qanswers group by userid) group by cq;
<0> ERROR 1248 (42000): Every derived table must have its own alias
<0> hmmm
<0> wtf?
<0> i jsut wanted to run what upb suggested, but i fail at life :<
<4> so give it an alias
<3> can I disable the sqldumper.exe process?
<0> lol what does that even mean?
<4> select ... from () as my_alias
<4> "as x" is an alias
<0> how odd
<0> ok that works
<0> as hack
<0> lol
<5> as is not a hack
<5> :D
<0> so
<0> i interviewed a sysadmin yesterday
<4> :(
<0> he didn't know how to redirect stderr :<
<0> i was very sad
<5> piss on em
<0> then he had mysql on his resume
<1> must have been an mcse
<0> and nfs
<0> wait
<1> it isnt hard to service mysqld restart
<0> he had "mysql certification"
<5> everyone knows what nfs is, need for speed
<1> and call yourself a dba
<0> and i was all "ok, so do you know how to start replication?"
<0> and he's all "oh i did that two years ago, i don't remember anything from that."
<0> D:
<0> wtf
<1> mysql certification is "creating and using databases and tables, inserting, modifying, deleting, and retrieving data"
<0> then i was just going to ask him what port nfs was on and stuff
<0> and he was all
<0> "i don't know anything about nfs"
<0> i really had to restrain myself from banging the phone over and over and hanging up
<0> i think next time i will do that
<5> the NFS port is on `cat /etc/services | grep nfs`
<1> yeah and to us, you look just as stupid by using the word "tuple"
<0> 2049
<0> or something
<0> <- doesn't have "dba" on his resume
<0> :D
<5> what does nfs have to do with dba?
<0> what should i say? "row"?
<1> i wouldnt know what port nfs is on and i dont care
<4> Jarett_ or calling "as" a hack
<1> its running great on 100 of my servers
<0> this is for a sysadmin
<0> not for a dba
<1> i dont need to know the port on any of my firewalls
<0> senior sysadmin
<1> I dont need to know it for anything
<1> never have
<0> who lists nfs
<0> it was a question to determine if the guy had any "elite" qualities
<0> i was going to ask him what other services and stuff need to be running for nfs to run and such
<1> thats far from elite
<0> but he didn't even get that far
<4> people that ask crap like that in interviews are just reflecting themsevles
<0> tenfour: true
<1> i had an idiot at oracle ask me about nohup
<0> i expcet someone to be a better sysadmin for me
<1> and i didnt answer it the way he wanted me to
<1> and that idiot had to balls to say i was wrong
<0> lol what did he ask you?
<1> moron
<1> "whats nohup"
<0> i forget, it's something that basically blocks sighup then runs the program
<0> right?
<1> and i said, its a ghetto old deprecated screen
<0> so when you logout it doesn't get terminated
<0> ah
<1> and he didnt realize he was old or didnt know what screen or dialog were
<1> so his stupidity was unable to comprehend that i was correct
<0> so basically you have an attitude problem and you hoisted that onto the interviewer
<0> that's cool
<1> I was smarter
<0> did you get the job?
<1> of course
<1> Im always smarter and better than the people who interview me
<1> thats why they are managers
<0> true
<0> i'm a manager now :<
<4> haha
<0> but i code
<1> go figure
<0> a lot
<0> :<
<4> i am a manager out of necesessity, not because of beurocracy
<4> i still code
<0> <- cto
<0> :<
<1> lol
<1> yeah right. you got ****ered into that title
<0> true
<1> i bet it was a practical joke
<0> 100%
<0> i got pwned
<1> "hey bob, lets make this fool have a 3 letter title..."
<1> sort of like that eddie murphy movie
<4> haha
<1> where 2 rich old guys had a bet to turn a homeless man into a moneymaker
<0> i am acutely aware of how badly i got pwned
<0> you mean that movie that on at least two stations every weekend
<0> ?
<1> no, when all your mysql dbs crash and you have no way to recover them... that day you will
<0> we have backups
<1> or when it accepts 31-feb-06 and doesnt return an error
<0> lol
<0> also i know mysql is poop
<6> CTOs should have the power to make the decision to replace it.
<0> i told one of my guys that the problem was that he was forgetting the first rule of argueing with me
<0> that i'm always right
<0> uh
<0> it works for us
<0> pivoting the company now would be foolish
<0> we'll fix it up someday
<4> famous last words
<0> we don't have the resources to migrate
<1> i love seeing that :P
<6> Entrusting your company data to a database which lacks integrity is foolish.
<0> we have more important things to hack on
<0> halo: i agree
<0> i used postgresql for another project
<0> that was kinda hardcore
<6> A Ford Pinto technically works, but that doesn't mean I would drive one willingly.
Return to
#sql
or
Go to some related
logs:
#computers
#beginner
kitty ate my megahurtz
#redhat
#bsd
#goal
#allnitecafe
#politics
REDNECKS IN TORONTO
#politics
|
|