| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> wtf?
<1> t I wouldn't work for a database snob anyway
<2> Feel free to use MySQL. Feel free to join #mysql.
<3> You're completely missing the big picture.
<3> But, that's pretty normal.
<4> DrToast: i get the distinct impression that you never have nor will you ever work in any DBA role of importance. :)
<5> DrToast: basically all the people in this chan that answer questions are telling you that you are an idiot... mabye we know something you dont?
<1> please enlighten me oh great and wise one
<0> man... 1 noob waiting to ask like a query and watching u guys tear each other apart
<2> If being a snob includes ensuring that billions of financial transactions are all accounted for, then so be it.
<2> Losing one means a lawsuit.
<1> and maybe this channel is an echo chamber
<4> killsalot: what's your question?
<1> I'll give you a second to look up what an echo chamber is
<3> Please to be cleaning up the channel. This has moved past old into annoying.
<2> What are you, 14?
<4> DrToast: i work in the telecom industry, others here work in the financial sector, what do you do?
<0> ok.. well wat i need is... hold on i gotta recheck
<2> He puts his MP3 collection on his blog.
<2> yay
<1> Halo_Four, for financial stuff you'd use transactions
<4> you don't ****ing get it, transactions are not a feature you 'turn on' when you need it
<1> to store the locations of uploaded images, its not as important
<5> DrToast: just shut up man
<1> see the distinctions there?
<4> it's an INHERENT PART OF THE DATABASE THAT ENSURES DATA INTEGRITY
<1> SicLuDe, why am I making you think for a change?
<2> I'd also use CHECK constraints and foreign keys.
<2> I'd expect any attempt to insert data violating those constraints to fail.
<6> sql2k, is it possible to get a concatenated string of values per row of a parent query from a lookup table without resorting to a udf?
<5> dfworking: huh?
<6> ****, ask a valid question and the world stops spinning
<7> we can only flame here, sorry
<5> dfworking: example? :)
<6> i have a query that returns users, and there is a lookup table that has usergroups, the user can belong to many
<5> dfworking: only if you dont have transactions
<3> Sorry df. I'm still trying to figure out why in god's name you'd want to turn off transactions.
<5> Drk`Angel: heh
<6> i'm asking if there's a way to get the values into a flattened single string without a udf
<0> turn off transactions?
<6> i have transactions turned on on all of my indexes man
<6> so its definitely not that. definitely not.
<5> select user, (select @blah = @blah + group from grouptable where user = a.user) from usertable a
<5> ?
<5> dont know if that works...
<6> well, i have multiple rows in the outer query, will blah reset itself for each iteration?
<5> ya dont know..
<6> like tits on a bull
<5> slipknot :)
<0> o_0
<5> dfworking: there should be a way
<0> "update main set gold=gold+("+i+"*miners*(50+5*minelevel));" wil this query work?
<0> asp btw
<5> dfworking: ya i think u might have to use a temp table or something
<6> in what way are you suggesting
<5> killsalot: run it?
<5> see what it generates
<5> and u meant vbscript
<0> alrite.. no asp with jscript
<5> huh?
<5> o ur using asp with jscript
<5> ok well u should see what it generates
<0> yes
<5> and then run the script
<0> well it works thanks.
<5> lol
<1> yay I got my question answerd in 2 minutes in #mysql
<1> see transactions do take too much time
<5> DrToast: actually i dont think you actually asked a question
<5> but stay in #mysql
<1> I couldn't
<1> transaction overhead
<5> dfworking: dont have a db to test this against but what if you did: select user, (select @blah = @blah + group from grouptable where userid = a.userid), @blah = '' from usertable a
<6> ok, that may work
<6> i'll let you know
<1> anyways I'm off to make some tables without transactions
<1> peace out
<5> thank god
<5> transactions belong to tables?
<4> 'anyways, i'm off to prolong my ignorance!'
<5> you know u have been using SQL for too long when you use ' instead of " :)
<3> Sic: I use a pile of languages. I get string quotes messed up ALL the time.
<5> anyone know of any good articles on horizontal partitioning on oracle?
<8> http://sqlonrails.org/
<8> hahah "SQL on RAILS is an open source web framework that's Optimised for language consolidation (gee, I feel like I took too many languages out on loan and need to consolidate!) and breakneck collaboration (wow, how would I collaborate if all of our necks were broken)
<8> hehe, I downloaded it and read the readme:
<8> INSTALLATION
<8> -------------------------------------
<8> see INSTALL in this directory.
<8> USAGE
<8> -------------------------------------
<8> SQL On Rails is entirely self-explanitory and fool-proof.
<8> that was all of it
<9> nice
<8> haha, jarrett banned me from #oracle for no apparent reason, other than maybe he didn't like that spoof URL: http://sqlonrails.org/
<10> That was a "because i can" ban
<5> lol
<11> why did you ban him though? :)
<3> Why ask why? :)
<10> i told you why.. because i can
<11> why
<11> why can you?
<12> reason #425 not to idle in #oracle
<13> sql on rails?
<8> heh, yeah
<8> why not?
<8> the downloaded zip is funny, I haven't looked at the video yet
<11> retarded
<14> retartet
<11> why would anyone waste time on bull**** like that
<12> 4/1
<8> dood, it's a spoof
<8> it's totally making fun of web 2.0 crap
<8> ...it was released APRIL 1, 2006!
<15> can someoeon tell whe the correct syntax to update more than one field in db? All i see examples of is update tablename set fieldname='value' where ID='currentId' how do i do more sets or do you have to do them one at a time for each field?
<16> field1="value", field2 = "value2"
<16> it's comma separated
<15> so like update foo set myval1='so in so', myval2='something else' ?
<16> yes.
<15> ok thanks will give it a shot
<16> you can even do this
<16> update table_NAMe set f1 = f2, f2 = f1 where blah..
<8> update thistable set col1=1,col2='stringvalue',col3=getdate() where {filtering}
<16> then u can swap the value of f1 and f2
<16> without having to go through those "temp" variable crap
<15> alright cool
<15> wll try thanks again
<16> have fun~
<5> http://www.nata2.info/humor/pictures/americans.gif
<5> yo u ever talk to jing?
<16> owned
<16> SicLuDe:: nope not at all
<5> she was in LI a couple of weeks ago
<16> why?
<16> oh...were you chilling with her by chance?
<16> for some reason, itend to forget names...
<16> so for a while, i was like, hmm who was she...
<5> lol
<5> ya i saw her
<5> she came with her husband
<16> hey, where at?
<16> oh.. she got married?
<5> by huntington
<5> ya jeff and his gf and all were there
<16> wowser.. i didn't know that she was gonna go for him that early
<5> some other asian chic too
<16> bah...
<16> wait a sec. jeff still going out with hmm marg... hmm something
<16> what's up with folks around me getting married and stuff all of a sudden...
<5> lol
<5> victoria
Return to
#sql
or
Go to some related
logs:
#windowsxp
qmail sslserver manual
#politics
#sex
#heroin
debian grub-set-default
#politics
#worldcup
#beginner
#solaris
|
|
