| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> jarett, have you ever heard of jerry black?
<1> kind of like that big metal dump truck thing you had when you were a kid
<1> except it's plastic
<1> and it doesn't hold dirt
<1> and it breaks immediately after taking it out of the package
<0> he's the main sys admin at realnetworks, you sorta remind me of him back in 97... he was all about freeBSD and Roxen
<2> freebsd ****s
<0> ...only he, of course, was sys admining real.com ..and you've probably admined a coupla boxes in your bedroom
<2> at least it wasnt bluestone and iis...
<2> nope in 97 i was contracting to the DoD
<0> actually the 'no support on open software' became an issue, so he hired the little brother of roxen's principle designer, he was one of the sharpest kids I ever worked with
<1> okay time for bber
<1> beer
<0> "contracting to the DoD"
<0> ...I'm going to let that one go for now
<0> heh
<2> good not like i would talk about it anyway
<2> plus you seem like an america hating sissy boy anyway.
<0> hey, how'dja like a b52 up your nose, fella
<0> heh
<3> I have about 700 databases (running mysql 4.1 on old server, 4.0.25 on new) and no grant tables for any of the users that belong to any of them on the new server we are using, we have the old server with identical databases with grant tables, but you can't simply dump and reload them into our new server and you can't copy the database directory due to version differences, that i'm aware of
<3> any help would be appreciated
<2> Infested, goto #mysql
<3> ok
<4> jarett: so you got very bored with your life and decided to become active in #sql? :)
<5> nm
<6> hey mixx
<5> hey
<7> i have two tables one is called basket and the otehr on is called product ...product has product_id,product description and product price..basket has the product_id and the customer_id . for example, if the customer orders product_id 2. i want it to look at the products table and show me the price and description for product 2.
<6> dmss : "i want it..."? "it" what?
<7> my query
<7> my page
<7> so really i'm trying to match the two product_id columns, and display what matches
<6> dmss : so what do you have so far? did you read the rules?
<7> i'm using Mysql
<0> select * from product p,basket b where p.product_id=b.product_id and b.customer_id=#myCustID#
<6> dmss : no mysql in this channel - try #mysql
<7> but its using sql queries
<0> it's ok, it's a real simple join...and if this is homework, you owe me royalties on all your future work
<0> understand?
<0> boy you guys are the ambasadors of goodwill, arencha
<0> dmss: select * from product p,basket b where p.product_id=b.product_id and b.customer_id=#myCustID#
<8> boo-****ing-hoo
<0> there's your code, now go away
<7> so you get kicked for talking about sql queries and for stating what database i am using, even though thatrs rule number 2
<7> yes thanks guest
<0> there's your code, now go away
<7> thank you very much, i will reference you
<7> guest2, irc network: undernet
<8> dmss : no mysql
<7> how is this mysql ?
<7> its sql
<7> no ?
<0> actually its EFnet
<7> sorry guest2
<0> dood leave now
<0> it ain't worth it trust me
<0> hehehe
<0> ...you see when I see mysql used for that sorta ****, I'm not bothered, but when they come in and try to do some funky joins becuas ethey can't subquery, then I tell them THIS IS WHY YOU NEED A REAL DATABASE
<8> i feel it`s better they learn early
<0> they don't though, all they think is what an ***hole you are
<8> boo-****ing-hoo
<0> heh
<9> lol
<8> oddly enough, the opinion of some random spod on irc doesn`t actually concern me
<0> oh no, I think newbs should shun people that have expereince... and then build ****ty code in the meantime
<0> nice work, why are you doing this BTW? is it some sort of thing where you ***ert your alpha-maleness?
<0> ...on second thought, don't answer that
<8> nope - i do it because i actually enjoy helping people
<0> it shows ;D
<8> well, that ****er got the right help - pointing to #mysql - and got arsy about it
<8> sp **** `im
<8> it`s not like people don`t get to see the rules when they join the channel
<8> and if they`re too stupid not to at least lie about the rdbms they run, they`re too stupid to help anyway
<8> after all, unless the say that they can`t do subqueries or stored procs, how would we ever know?
<0> when you give them a solution that requires a subquery and they want a join instead,,,heh
<0> I nail 'em all the time
<0> but I hear ya...the guy /msg'd me **** like "so where's the price in that query" and I totally ignored him
<0> it was probbly a test
<10> I am looking for a creative way to unify the identity generation of two tables. I have an old table and a new table. I want old code which inserts into old table to generate record in new table... and new code to generate old record... until a time when I can modify all the old code. Triggers are easy, sure... problem is identities.
<10> Old code uses SCOPE_IDENTITY.
<10> And new code should too.
<10> If there was a way I could just set SCOPE_IDENTITY manually I could have teh trigger do it...
<10> but it doesn't look like ther eis.
<10> MSSQL.
<10> OH! I think I just figured it out. What a nasty nasty hack.
<10> I can make one table seed with odd numbers and one with even.
<10> ooh that's bad. ;)
<0> okie dokie
<11> j00 h4x0r
<10> Unless anybody has any better ideas.
<0> it's not a huge deal, but I still don't know what you're trying to do
<10> Well the big explanation should cover it.
<10> Specific questions?
<0> "and new code to generate old record"
<11> i didn't understand it either
<0> that one lost me..WHY?
<10> I'm changing the name of a table.
<10> And need old code to continue working, generating new stuff.
<0> ok
<0> why does new code need to make old records then?
<10> Doesn't anymore, actually. The reason I ***umed it did was because I had to have new and old id's non conflicting.
<0> you've got old code making new records, then new code should make new records as wel, no?
<10> Sure, but the old code has to be able to figure out what identity it just inserted.
<10> Using SCOPE_IDENTITY>
<0> ok, soit's still making these in the new table, right?
<10> Old code isn't.
<10> Old code makes it in the old table.
<10> (as I cannot change old code)
<0> oh
<10> If I had changed the old code, it would have been new code. ;)
<0> yeah your terminology is quite confusing
<10> Sorry.
<0> when you said 'new records' I ***umed you meant records in the new table
<10> I'm jsut trying to change the name of a table while keeping everything working.
<10> Since there are about 10 projects using the table currently, and I can't change and deploy them all at once.
<11> so don't change the name of the table
<11> just make a new blank one
<11> or a view
<10> can't insert into views with identities properly.
<10> old code inserts.
<0> what has changed in the table besides the name?
<10> Name's of a few other columns, some columns are now missing.
<0> why does the new code reference a new table?
<10> Desire to keep things named properly. Short overview. Old table is named RequestStatus. new table is named EnrollmentRequestStatus, and different types of *RequestStatus are being introduced.
<0> oh crap..thats your nightmare
<10> If it became insurrmountable to rename it, I wouldn't be doing so... but it looks like this will fix it up.
<0> there are some things that are just not worth breaking what is already working...if you want to change all those names, then change the old code
<10> I will be.
<10> However it's not feasible for me to bring all the old code down at one time.
<0> well, you're a dba, make an announcement...or just store stuff in two tables for awhile and concatonate them later
<10> Announcements cost money. :0
<0> ..after you change all the code.. then you just need to move the records you ned from the old table to the new
<0> you're saying all of it is 24/7 traffic all the time
<10> Yeah, you're right, that would have worked, however both new and old code uses identities, I really don't want to be cleaning up overlapping ids in all the other tables that point to both of these two.
<10> Also the old code still needs to see new records, actually.
<10> Or financial stuff gets off. Blah.
<11> you want them to be concurrently running off the same backend?
<11> and merge the tables later? ew
<10> I don't "want" anything.
<11> hehe =)
<0> well hopefully your 'new table' isn't named what it will be ultimately changed to
<0> else you're screwed
<0> you might be able to play a view trick for a while on the reads
<10> hmm?
<10> Well, I can't ignore the writes.
<10> And they both happen to teh same name.
<0> but the view needs to be named what your table and cols will ultamately be nammed
<0> ...and it looks at both the 'tables' old and new
<0> unions them
<10> Bah. IDENTITY_INSERT needs sysadmin or owner.
Return to
#sql
or
Go to some related
logs:
homless count in sf
#politics
#politics
#windows
#beginner
#stocks
#dreamweaver
#microsoft
french pelenty shootout games
#c
|
|