| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> Yes
<1> yes
<0> no
<2> but your dba will hate you if you do
<0> Your DBA hates you already
<3> lol
<3> i am the dba
<4> in a table i have 3 row: documentid, ***ignmentid and courseid... i search a way to select all ***ignment id where there a not document id linked to it
<2> will "Joins are better" ?
<5> Therion: should i delete one of them or modify?
<0> Don't be hatin yourself
<0> osfameron, YES
<0> magyar, Delete the INDEX
<3> will: what version did it start in?
<2> righty ho, I don't suppose I need a reason :-)
<6> magyar: delete the index, retain the primary key
<0> Syco54645, 5.0.15
<2> some guy on irc said it, that's good enough for me :-)
<3> thanks
<1> nice clean clear disambiguated joins
<6> osfameron: Good!
<5> Therion: will: thanks
<0> o hahaha
<0> I thought you said what version I started in.
<0> See, I see gay
<6> Syco54645: cross-database joins? uh... 3.21?
<3> will: i was thinking that sounded a bit off
<0> No osfameron sounds a bit off
<2> cross db joins is great for data-warehouse stuff
<3> Therion: yes. well my site has 3.23.58 on it... so i guess it supports it
<2> in production, it means you're ties to haveing the 2 dbs on the same machine
<6> osfameron: a subquery that can be expressed as a join should be expressed as a join. Not all of them can.
<2> (I don't think you can do cross-machine joins)
<6> osfameron: as with anything else, there are always exceptions
<2> Therion: even when it is clearer as a subselect?
<6> osfameron: Clearer in terms of the relational model or in terms of someone who doesn't knwo what he's doing trying to interpret it?
<0> Clearer to who?>
<2> Therion: are there exceptions to the rule that there are always exceptions to every rule?
<6> SELECT * FROM t1 WHERE t1.id NOT IN ( SELECT t1id FROM t2 );
<6> Sure, it's clear
<6> But an outer join is the proper way to do it
<2> clearer in terms of intent
<6> Clearer in intent only to people who do not know what they are doing
<0> Intent ****s.
<2> sure, I get that there are idioms and such
<2> perl has those (and line noise!)
<0> I don't understand subqueries as well as joins.
<6> Anyway, optimizers have an easier time finding optimal plans when you use joins, in very many cases
<6> Subqueries are overused by amateurs, basically, so they have a "bad rep"
<2> fair enough
<6> Nothing wrong with them in and of themselves, though depending on the engine some subquery forms may have horrible optimizations
<2> this is of course why we have dbas
<6> http://www.onlamp.com/pub/a/onlamp/2004/09/30/from_clauses.html
<6> heh
<2> I'd like to be able to prototype a query "this is what I want"
<2> and then get the dba to optimize it
<2> unfortunately, we don't work that way at my place
<6> osfameron: Ahhhh, that ****s
<2> I can ask him about stuff for particularly heavy queries, but doesn't happen as a matter of course
<6> will: Change your nick to "swill"
<0> Is Syco54645 your DBA?
<6> will: Do you watch Lost?
<6> osfameron: One would think the DBA would want to ensure that every query touching "his" database was performant and well-written. ;)
<2> eeeek! I need to pack my flat into a bag before I go to work, why am I on irc? :-)
<6> I hope you have a small flat or a very large bag
<2> Therion: yeah, our dba is maybe too laidback :-)
<2> well, I might need a couple of bags...
<2> laters
<3> i am will's dba. in fact my other machine is his linux box
<3> ;)
<3> well swill's dba rather
<7> that's okay, my other database is yours.
<1> I've been reading up on sql modes
<8> What's going on?
<8> Stop talking when I'm on the phone
<6> bobfield: We used a ouija board to channel Ernest Hemingway's spirit to write about SQL modes just for you.
<6> swill: Stop being on the phone.
<8> Why not?
<8> pick up hahaha
<8> j ust kidding i have to go to the broom
<6> haha
<8> b-room
<6> dude
<8> bathroom
<6> call me and hang up
<6> punk
<1> I blogged about access and non-transactional storage engines, and arjen said something about sql modes
<6> lobotomy
<3> vandemar: i was wondering why all of those weird hyperlinks to granny porn were in there
<6> woo granny porn
<3> i thought i had some strange inserts
<6> bald midget proctologist porn is more my style
<4> i have half of a solution to my query.... maybe someone can help me...... i posted all my problem to: http://pastebin.com/632081
<1> I can't find the sql mode controlling transactional operations on non-transactional engines
<6> there isn't one
<3> so i have a good question
<3> why do so many people hate db
<3> there is hardly anyone at my school that would do it for a job
<9> db's in general or mysq;?
<3> i personally wouldnt mind
<3> just general dbs
<3> like in cl*** we used oracle 9i
<9> well anyone who hats db's in general is an idiot because _everything_ is a db of some sort
<10> Syco54645: because data-entry/manipulation is "boring"
<3> bashusr: eh i dont know. i like writing queries
<6> Syco54645: Partly because set-based thinking is difficult for most people
<9> you are one of many. you will get paid well someday Syco54645
<6> Syco54645: Partly because people don't want to actually do work. ;)
<3> Therion: object oriented thinking is a pain to me
<3> Therion: i will admit that mysql has frustrated me a few times, but it was more stupid php things than actual sql that was wrong
<9> everything is OO
<3> blobaugh: not really.
<9> Syco54645: show me something thats not
<10> Syco54645: all the money is in OO :-P
<10> unless you want to write one long program that isn't "pluggable"
<3> blobaugh: perl unless you use poe
<3> bashusr: i didnt say that i dont like oo. it just is a pain in the *** for me to think in those terms
<9> Syco54645: perl is an object in and of itself
<3> blobaugh: hogwash... haha i said hogwash on the internets!
<3> blobaugh: well yes, but you cannot program objectively without poe
<3> i thought you meant a language
<9> your computer is an object too, ever think about that one?
<10> blobaugh: now you're getting silly.
<3> blobaugh: there is no spoon
<3> amiga was an object oriented os!
<9> thats cause i stole it ;)
<10> Syco54645: isn't perl "OOP"? how do they have CPAN?
<3> boo ya
<3> bashusr: to program objectively i thought you needed poe
<3> i could be wrong.
<10> what's all the stuff in CPAN written in then?
<10> (i don't program regularly with PERL)
<3> they are modules
<10> http://poe.perl.org/?What_POE_Is
<3> like headers
<10> uhh..
<3> which are objects yes
<10> POE seems to be event-driven instead of... oh what's the antonymn of event-driven?
<3> oh poe was the threader
<3> i didnt say i cant/wouldnt do oo, i just said it was a pain in the ***.
<3> but you are right
<10> ahh.. when your program just executes down the line of code
<3> oh vb isnt freaking oo. vb6 that is
<3> well you cant program oo in it
<1> g'night y'all
<3> night bobfield
<6> Syco54645: Amiga OS was nice. ;)
<3> Therion: yes i know... if i wasnt a broke college student then i would get an a4000t
<10> you have cl***es, functions, etc.
Return to
#mysql
or
Go to some related
logs:
i think it's a bunch of bullshit morrison
#suse
#web
vimp dump
ubuntu logitech dinova
#ubuntu
d2gs 1.11
#fedora
module k750i menuconfig
#web
|
|