| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> well how exactly is cycles different to 4proc.cycles ?
<1> that may be easier if it may be an invalid table name :)
<0> are you trying to see if there is more than one value for cycles ?
<1> with cycles I mean the field cycles from the subquery, with 4proc.cycles I mean the value cycles from the main query
<0> so why are you not just using a self-join ?
<1> aha, that's new to me :)
<1> i'll check it out
<2> hey got a few q's for anyone with innodb knowledge
<1> tnx :)
<0> it would simplify your query somewhat :P
<3> msg SQL commands
<1> tnx andrewbryson :)
<0> working already then ? :P
<1> didn't know about self-join, looking up :)
<1> i now have this:
<1> select distinct c1.cycles,c1.power from 4proc as c1, 4proc as c2 where c1.cycles < c2.cycles and c1.power < c2.powe
<1> r
<0> heh it is better to use the explicit join command
<1> mmz, should be select distinct c1.cycles,c1.power from 4proc as c1, 4proc as c2 where NOT (c1.cycles < c2.cycles and c1.power < c2.power)
<1> ?
<0> SELECT DISTINCT c1.cycles, c1.power FROM 4proc c1 JOIN 4proc c2 ON NOT (c1.cycles < c2.cycles AND c1.power < c2.power)
<0> there are subtle differences between the way that conditions in the ON clause and those in the WHERE clause behave in certain queries
<1> ok, tnx, will try
<1> mmz, takes a lot of time :)
<0> the query ?
<1> jep, using it on 16000 values :)
<0> do you have indexes on that table ?
<0> 16000 is tiny so a query like that should be almost instant
<1> no, not indexed
<0> although returning several million rows will take a while
<1> that would help probably :)
<4> hi
<4> hey what's a triangle mean in an ER diagram ?
<4> ah found
<5> what is it?
<4> well when you got a supercl***
<4> the supercl*** is connected to the top point, and the 2 subcl***es are connected to the other 2 points
<4> you then right ISA In the middle
<4> ah Is A
<4> ok, duh
<0> lol
<5> is this an ERD or an object diagram?
<4> i'm still way to drunk to do this lol
<4> got home when the sun was rising
<0> sounds like a good reason to have another drink
<4> infi an ERD
<0> it will all become clear then
<4> andrewbryson :D
<5> perhaps they're the same, but I think of ERDs more as a database schema description
<4> infi it actually is
<4> you awnt to see it? ;)
<4> http://www.iam.unibe.ch/~kai/Lectures/DB7.pdf
<4> 2nd page
<5> yeah, if you won't regret giving out proprietary info when you're sober ;)
<4> lol it's some stupid thing for university ;)
<6> radical graphics
<4> lol this university is THE ****.
<4> i don't even know why im doing CS at university anyway
<4> i should have just went on with the chemistry + biochemistry at the other university
<6> stop bitching
<6> how's the quest for DENSE_RANK?
<4> hm ok, they have a ISA triangle.. and wrote "disjoint" next to it.. disjoint means OR... BUT.... does this mean it can be 2 of the subcl***es?
<4> yeah see Leith, if i wouldn't have to do crap like this, i could have implemented RANK a long time ago
<6> heh
<4> i'm just scared, that when i'm like 45 or something, with family and kids...and suddenly don't have a job anymore.. i'll be without luck if i don't have a degree
<4> but maybe i'm wrong... computer science is usually about showing what you can do, and what you have done
<6> depends on the career you've had leading up to 45
<4> but with 45, you don't even get interviewed anymore without a diploma
<6> me - I want to be retired at 45 :P
<4> hehehehe
<0> hell i want to be retired long before then
<4> well... can you pay for your teenagers on retirement money?
<4> you know that's when they want big things... pianos... cars :D
<0> lol i doubt that they could want to spend as much as i would :P
<4> hehehehe
<0> so i suspect that the answer would be yes :P
<0> of course that is ***uming that society does not collapse completely by then
<0> which it might well do :P
<4> no seriously, i mean i don't know how old you guys are, but what are your rough future plans?
<4> hm that's true.
<6> to take over the world
<0> well mine are to open a few more businesses and then retire
<4> wtf, that's mine >;/
<0> at the moment i make about 3/4 of the national average wage before i get up
<6> i'm 27, 2 kids already (and having no more)
<6> and quite happy in my job :)
<4> well you're at mysql ab or?
<6> uh huh
<0> i figure if i can make about twice what i do now without having to do any actual work then i can afford to retire :P
<4> get me a job there. i'm sure they need a branch office here in Switzerland ;)
<0> heh
<4> man, 27, 2 kids... i better get started.. grml
<0> lol
<4> did you ever go to university Leith ?
<6> nope
<4> see.. gah
<0> don't fret - i am 34 and still have no kids :P
<4> they don't believe me.
<6> heh
<4> andrewbryson more money for your toys!
<4> :D
<0> :P
<7> ***uming he has no spouse to get rid if his disposable income :-0
<0> nope she vanished :P
<4> hah, yes another determining factor
<4> i could use one of those too sometime
<0> so basically is just me getting rid of disposable income at the moment
<6> one of the lucky ones ;)
<0> :P
<0> must get me another some time
<0> is hard to get rid of all of my disposable income by myself
<0> it just accumulates
<7> Lucky you!
<7> I have a spouse who could help you ...
<0> lol
<0> oddly enough it is not difficult to find someone to dispose of cash
<5> go go, prenup :)
<0> lol infi
<4> hm what does double line or thick line mean in ERD again?
<0> do people actually use those in real life ?
<4> not sure. i mean it may be useful if you have a huge app.
<4> If all entities in an entity set must participate in a relation in the relationship set, a thick line is drawn - not sure i understand that
<4> "This is called a participation constraint"
<4> does it mean, must occur at least once?
<5> I do for larger projects, but mine describe the table structure in depth...
<5> that ERD was .. odd to me.
<5> table and relationship structure, that is, including columns and types, etc.
<5> shhh, the fuzz is here
<5> hi lilo!
<8> hi all. I need to install mySql as part of my application..i found how to do it in linux but i need it also in win32 os. There is a way how to find info about a custom install of mysql?
<9> iwkse: there's windows install package at mysql.com
<8> i don't need windows install package
<8> i need to create a own installer
<10> use the zip package then
<10> for windows..
<8> yes
<8> but i need to configure service and registry
<8> i need info about it
<10> you don't need to configure the registry
<10> just use "mysqld-nt --install servicename"
<8> ok...
<8> ok
<8> but i also need to setup things as in the installer
<8> eg. root p***word, db type..
<6> well you need to go off and script all that then ;)
<6> check out things like mysql_secure_installation
<6> mysqladmin will set a root p***word
<6> etc.
<8> so i remember i already made it time ago
Return to
#mysql
or
Go to some related
logs:
upgread to XOrg 6.8
#python
#perl
debian strings command apt-get
#perl
#php
mdadm --grow
10.2 ACR38 Slackware
dapper realtek ac97
cannot find terminfo entry for rxvt-unicode
|
|