| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> archivist: haha its a joke : keep your panties on
<1> lodoss - I think the joke is on you
<2> lodoss - sjrussel isn't wearing any underwear
<1> I free, Jerry!
<3> hi.... i would like to know what tool do you use to diagram the DB structure?
<2> my brain
<1> the markers don't come off when I write on my forehead
<2> you'd have to actually wash for that to happen
<1> heh
<4> !m p***word reset
<5> p***word: (RESET Syntax) : http://dev.mysql.com/doc/mysql/en/RESET.html
<6> !man reset root
<5> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<7> is this not correct syntax? I'm not sure the best way to do it.. http://pastebin.com/526392
<7> Anyone?
<7> :-/
<6> no where distinct
<6> !man select syntax
<7> i just need to count MEMBERSHIP.MEMBER_NBR but I only want to count the ones with distinct INDIVIDUAL.INDIVIDUAL_NBR
<5> (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<7> I've looked at that, I'm just a bit confused
<6> !man group by
<5> (GROUP BY Modifiers) : http://dev.mysql.com/doc/mysql/en/GROUP-BY-Modifiers.html
<7> argh I know all this, I just cant see how to put it together...
<7> group by distinct(individual.individual_id)?
<6> group by individual.individual_id
<7> right, but that doesn't give me back one number
<7> That gives me the number of member_nbr per individual_id
<8> kind of a noob question, but is there a way to stop a master aside from stopping each slave individually?
<7> archivist see what I mean?
<7> I get 32448 rows that way, instead of one
<7> http://pastebin.com/526402
<9> hi.
<7> i just wanna see the total amount of member_nbrs with unique individual ids
<9> does anybody knows something about the transactionnality of auto_increments ?
<9> it seems that when you rollback a transaction, the auto_increment "next value" isn't rolled back too
<6> it couldnt as another transaction concurrent could be adding as well
<10> is there a way to parse arbitrary date strings
<10> like '%m-%d@%y'
<10> why yes
<10> str_to_date
Return to
#mysql
or
Go to some related
logs:
#math
portege s100 xorg.conf
#openzaurus
#perl
#perl
knoppix md0 mdadm segmentation fault
Failed to load module GLcore (loader failed, 7)
#perl
#debian
planonomics
|
|