#mysql
21 October 2007
Total 22 pages. You are browsing page 5/22.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
02:20 <****> flexo: something can't = NULL, but it can be NULL.
02:20 <****> oh okay, thanks
02:20 <****> question though
02:20 <****> why's = null work in the ON
02:20 * voidy is doing another 6 hour database transfer :(
02:21 <****> flexo: By definition. NULL means unknown. So x = NULL can never be true or false.
02:21 <****> chadmaynard: it was my error.. WHERE criteria was not supposed to check uniqueID, but another column in table1.. your code works great.. thanks
02:21 <****> Okay, so it's just a bug where it's working in the LEFT JOIN....ON line?
02:21 <****> I knew I must be missing something..
02:22 <****> fresh coffee and a break from code works wonders :)
02:23 <****> flexo: When sid is not null the result is correct.
02:23 <****> flexo: So there can be some correct rows produced.
02:24 <****> um, okay. Not really following what you're responding to though.
02:25 <****> I'm just questioning the syntax at this point. w.nid = NULL worked, but w.sid = NULL didn't. So now I've been told it should be w.sid IS NULL ...which I understand...but then my question is w.nid = NULL should also be w.nid IS NULL. correct?
02:26 <****> flexo: right
02:26 <****> Okay, thanks. :D
02:27 <****> flexo: Well, w.nid = NULL did not "work".
02:27 <****> flexo: the result of (anything) = NULL is NULL
02:27 <****> even NULL = NULL is NULL
02:27 <****> wouldn't results of a check be true or false...not null?
02:28 <****> flexo: No. NULL is known, so any equality test with null is unknown, neither true nor false.
02:28 <****> oh, I see. I never new that could happen
02:29 <****> flexo: SELECT NULL IS UNKNOWN, NULL IS NOT UNKNOWN;
02:29 <****> Right, I follow you now. thanks.
02:31 <****> Also: SELECT NULL IS true, NULL IS false;
02:32 <****> Finally: SELECT NULL = NULL;
02:33 <****> chadmaynard, like I was saying yum sucks, I just installed mysq via yum and it gives me abunch of errors.
02:33 <****> cmanns: doesn't hurt my feelings. I am of no relation to yum
02:34 <****> Wasnt saying to hurt your feelings chadmaynard I don't care for those distro wars just saying, yum sucks.
02:34 <****> Over 3 things it installed incorrectly today :(
02:35 <****> Anyone know of a guide for installing mysql from source?
02:35 <****> sounds like a distro problem than a yum problem
02:35 <****> I get no errors when i start it it just starts and stops.
02:35 <****> cmanns: did you populate the mysql database?
02:35 <****> No, I need to do that?
02:35 <****> using mysql_install_db that is
02:35 <****> cmanns: generally a good idea, yep
02:35 <****> cmanns: mysql is fairly simple to install by hand. I wouldn't risk having the auto install witch doctors do it.
02:36 <****> cmanns: But not using yum (or similar) shouldn't drive yuo to build from source. Just grab a pre-built binary.
02:36 <****> you'll auto install it if you still want corporate support
02:36 <****> I ran that, ran fine chadmaynard still starts and stops :S
02:36 <****> cmanns: check the log
02:37 <****> The .err? Has nothing in it :/
02:37 <****> cmanns: maybe mysql can't write to the log
02:38 <****> k, I chown the files, now its staying on :S
02:38 * cmanns goes to finish php and such
02:38 <****> thanks
03:01 <****> cmanns: you might 'chmod 600 log'
03:02 <****> mikegriffin: why? he said it worked
03:02 <****> chadmaynard: no one besides root or mysql should be able to read it
03:02 <****> mysql will create the log with the correct permissions.
03:03 <****> chadmaynard: if mysql created said log, no chowning would have been needed
03:03 <****> is that so
03:04 <****> a non-privileged user can only create files as themselves right?
03:04 <****> unless you use sticky bits
03:05 <****> Even if you use sticky bits they can still only create files as themselves. Some Unix-likes allow "giving away" files to other users, but Linux doesn't.
03:06 <****> Simetrical: i was talking about group i suppose
03:06 <****> I assume you can change the group of a file you own to any group you're a member of.
03:06 <****> but you are correct
03:06 <****> Why are we talking about who can create what files?
03:06 <****> I dunno.
03:12 <****> so whats new in 5.1 again? events, pluggable engines, status like 'inno', ...
03:13 <****> Apparently some improvements to index usage, according to a discussion I had with chadmaynard a few days ago.
03:14 <****> that's 5.0
03:14 <****> any of those in 5.0?
03:15 <****> oh right rbr
03:15 <****> http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html
03:15 <****> chadmaynard: awesome thanks
03:16 <****> partitioning is pretty cool too
03:23 <****> so you guys think it will be ga near jan or feb?
03:30 <****> Awww, Blackhole doesn't support row-based logging. :(
03:31 <****> row based logging ?
03:32 <****> binary logging ?
03:33 <****> hello
03:33 <****> any way to merge the results from multiple SELECT query's inside a procedure?
03:34 <****> UNION?
03:34 <****> Simetrical: wow, that seems to be what i'm looking for ;)
03:35 <****> still not sure how to use it inside a loop, tho
03:36 <****> what about when i'm doing a while loop that does a SELECT inside each iteration
03:36 <****> and i want to merge those results
03:36 <****> can UNION do that somehow?
03:37 <****> I dunno, I never use procedural stuff for MySQL, personally. I just run queries on it, and use a scripting language for things like loops.
03:37 <****> Simetrical: mee too, but this time i need some more speed ;)
03:38 <****> What are you running that you have to execute queries repeatedly in a loop?
03:39 <****> I have a table (exported from an app) that defines groups of items
03:39 <****> these groups are separated by dots
03:40 <****> things like CC.FM.ST
03:40 <****> That's bad.
03:40 <****> You should have them in their own M:N table.
03:40 <****> i need to trace back those groups and find a description in a different table corresponding to each group
03:40 <****> i know, unfortunately i didn't create the table
03:40 <****> Well, as I say, I dunno. Good luck.
03:41 <****> tnx :)
03:42 <****> i think i'll probably need a temporary table
03:44 <****> i am looking for a linux gui tool for mysql
03:45 <****> i see mysql-query-browser, mysql-admin and mysql-navigator in my package manager.. is there any difference between these
03:45 <****> any recommendations?
03:46 <****> i have a question regarding the design of my database.
03:46 <****> is this an appropriate place to ask?
03:46 <****> is there an easy way to decrement a value without selecting it first?
Total 22 pages. You are browsing page 5/22.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last