#mysql
25 December 2007
Total 9 pages. You are browsing page 1/9.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Tue Dec 25 00:00:46 2007
00:24 <****> archivist, if you are still here, can I ask you something please?
00:25 <****> Do I understand it correctly that any RIGHT JOIN can be achieved using a LEFT JOIN and reordering the parameters?
00:25 <****> that's correct
00:26 <****> is that because of performances issue I guess?
00:26 <****> litheum, thank you for answering that. Do you know why the RIGHT JOIN is included in the commands then? Why bother with it?
00:27 <****> sometimes it will be more convenitnt to arrange it in that way or easier to lay it out
00:27 <****> Isn't RIGHT JOIN part of the SQL standard?
00:29 <****> Simetrical, yes, I wasn't critisizing mysql or anything, I was asking why it is in the sql standard at all
00:30 <****> I dunno, why do you ever have two ways of doing the same thing?
00:30 <****> thank you litheum
00:31 <****> Simetrical: only 2 when you're very lucky :)
00:52 <****> so I click the updates icon on the top right panel of gnome on gutsy to install the new mysql 5.0, this returned an error of course
00:53 <****> It was suggested that I uninstall mysql from my system, and then install it again using https://help.ubuntu.com/7.10/server/C/mysql.html
00:53 <****> sure enough, when I try and configure an admin password, I get problems
00:56 <****> is there an easy way to grant access to all tables except a few.. I have around 140 tables, and I want to give someone access to all of them except 3-4
01:00 <****> devicenull, write a script?
01:01 <****> I was afraid of that :p
01:08 <****> hey all question on table types... what would be best to use for an interaface for my mail logs aprox 2Million rows a day
01:13 <****> oh yea ... and merry christmas for those who take part lol
01:14 <****> guys, does anyone know how I can write the following query using a left join rather than a right join?
01:14 <****> SELECT * FROM user_perm_group upg RIGHT JOIN perm_group pg ON upg.`group_id` = pg.`group_id` WHERE upg.user_id = '1' OR upg.user_id IS NULL;
01:14 <****> hal11 u use navicat??
01:15 <****> PodMan99a, no, what is that?
01:15 <****> i live with it for select queries.... crap for everything else
01:15 <****> semi WYSIWYG sql client but very detailed for waht it is... sure they have demo's
01:17 <****> PodMan99a, thanks I will look into it
01:17 <****> PodMan99a, merry Xmas mate!
01:19 <****> I just changed the two tables around and changed the command from RIGHT JOIN to LEFT JOIN, and it seems to have worked fine
01:20 <****> is it important which way round the comparison clauses go?
01:22 <****> would only expect so if its a very complex query
01:23 <****> hal11, no.
01:24 <****> Equality is symmetric, and AND is commutative.
01:24 <****> Simetrical, fantastic
01:24 <****> hmm, commulative?
01:24 <****> oh I see
01:24 <****> yes
01:24 <****> AND is cummulative
01:24 <****> yes I understand
01:29 <****> heh
01:34 <****> where can i goto get the best information regarding database design && normalization?
01:35 <****> did you hear about the party...
01:35 <****> ?
01:36 <****> it's gunna be the best... I'm so stoked.
01:37 <****> where can i goto get the best information regarding database design && normalization?
01:37 <****> Kline, any of a million different books or websites.
01:37 <****> i need a web resource
01:38 <****> like good articles
01:39 <****> Hey, did you know about the party after the show?
01:39 <****> juiop: what are you talking about?
01:40 <****> sorry, I'm out of it right now. ignore me :)
01:40 <****> haha
01:40 <****> you must be holiday drunken
01:40 <****> hehe
01:40 <****> and yes i mean alcohol
01:41 <****> alkline is good tho!
01:41 <****> lol
01:41 <****> alkline?
01:41 <****> ;)
01:41 <****> *zips his lips now*
01:42 <****> *err fingers even*
01:46 <****> lol
01:52 <****> anyone else in here?
01:52 <****> No.
01:52 <****> dammit
01:52 <****> i guess i'm shit out of luck
01:52 <****> That's why there are, uh, 383 people listed.
01:52 <****> lmao
01:52 <****> It's a conspiracy.
01:52 <****> pardon me, i'm a bit intox
01:52 <****> intox'd
01:52 <****> MySQL AB wants to make its chats look populated.
01:52 <****> lol
01:53 <****> They're all bots that occasionally say boilerplate things to look active.
01:53 <****> If you wait a little you'll see the standard 8:04 PM conversation about indexes.
01:53 <****> lol
01:53 <****> ok ok
01:53 <****> what is it called again
01:53 <****> N:1
01:53 <****> N:M
01:53 <****> or something like that
01:53 <****> i forget
01:53 <****> N:N
01:54 <****> What about them?
01:54 <****> what is it called ?
01:54 <****> i'm trying to look for information regarding this on the net, but i don't know where to start
01:54 <****> i'm working on mapping databases / tables, etc.
01:54 <****> Er, it's a way of describing tables.
01:54 <****> Don't know if it has a particular name.
01:55 <****> i want to do it correct the first time
01:55 <****> i think it has something to do with db normalization
01:55 <****> Well, yes, I guess everything related to database design does, in some fashion.
01:55 <****> cool
02:00 <****> do you know of any web resources i can check out?
02:01 <****> Not offhand.
02:01 <****> I mainly learned by glancing over Wikipedia, to be honest.
02:02 <****> Most of it is fairly straightforward.
02:02 <****> Oh, and some hands-on experience with decently-designed databases.
02:02 <****> That was very helpful.
02:05 <****> cool
Total 9 pages. You are browsing page 1/9.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last