#mysql
20 October 2007
Total 24 pages. You are browsing page 1/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Sat Oct 20 00:00:06 2007
--- Day changed Sat Oct 20 2007
00:00 <****> ah ha!
00:00 <****> what he sadi :D
00:00 <****> said
00:00 <****> What do you call that sub-query-parentheses thingy?
00:00 <****> (so that I can look it up)
00:00 <****> subquery
00:00 <****> well that was easy enough.
00:01 <****> I'll give it a shot and play around. Thank you gnari.
00:01 <****> wow, it's good to be in here to learn some stuff
00:01 <****> lolotov, of course you need the order by in the subquery
00:02 <****> gnari: would you need to order by in the subquery if you have max(x) ?
00:02 <****> lnxsmith, otherwise the LIMIT makes no sense
00:02 <****> hmm
00:03 <****> gnari: good point :)
00:04 <****> lnxsmith, it there are 100 rows where A=B then a LIMIT 5 wiyhout ORDER BY could as well be picking the 5 with the highest x
00:04 <****> gnari: yeah i realized that after i asked the question, stupid question
00:04 * foo slaps gnari
00:05 <****> long tome no see, foo
00:05 <****> time
00:05 <****> :)
00:06 <****> guys what is the most common utf8 collation ? I see many choices
00:07 <****> the one suits you the most
00:07 <****> I want one with accents :) just it
00:08 <****> why is this so difficult for me. i want to order /within/ a group clause. is that so hard?
00:12 <****> how do i check what users exist for mysql?
00:12 <****> you mean you want to order the grouped results ?
00:12 <****> that's normal
00:12 <****> amy_ select * from mysql.users ?
00:12 <****> *user, maybe
00:12 <****> i want to order within the group - i.e. before a set of rows is grouped together, i want to choose which row is on top, and thus, which row's data is returned as representative of that group
00:13 <****> how can i update table to generate unique uuid() for each record
00:13 <****> i don't care about the eventual ordering of the 'groups' after they've been grouped into single rows
00:13 <****> adaptr, no dice
00:14 <****> hypnos22: That's doable without a GROUP BY.
00:15 * hypnos22 thinks
00:15 <****> hypnos22: But that assumes you have such an ordering available.
00:15 <****> amy_ try mysql.user, also the other tables in mysql, since they hold more specific access data
00:15 <****> use mysql; show tables;
00:16 <****> can someone tell me where I went wrong ? $result = @mysql_query('SELECT * from csm where Status=\'Active\' or Status=\'Scheduled\' CSM_type !=\'Sales Lead\' order by Priority ASC');
00:16 <****>'); }
00:16 <****> adaptr, user is a table
00:16 <****> I think by CSM_Type ?
00:16 <****> Xgc: roughly speaking, what's involved. i'm usually pretty ninjatastic with queries but this one is just confusing me. i suppose i could use a subquery and select the row having the max created at for that group_id?
00:17 <****> I'm getting an error and I'm not sure what is causing the problem. http://pastebin.com/d29087f04
00:18 <****> hi
00:18 <****> adaptr, how do i show the user table in the mysql database?
00:18 <****> use mysql;
00:18 <****> raden_work, missing and/or before CSM_type
00:18 <****> describe User;
00:18 <****> brb
00:18 <****> tibyke, hmm still having a issue :(
00:19 <****> fuse, hrm, it's not showing any users in there at all
00:19 <****> raden_work, echo the query, and youll see
00:19 <****> amy_: are you doing select * from User; ?
00:19 <****> hypnos22: SELECT t1.* FROM tbl t1 LEFT JOIN tbl t2 ON t1.G = t2.G AND t1.O < t2.O WHERE t2.G IS NULL;
00:19 <****> how do i create a user in the mysql db? i'll try that first?
00:19 <****> tibyke, working on it
00:19 <****> amy_, mysql.com/grant
00:19 <****> amy_: see GRANT
00:19 <****> and keep off rtfm issues to mysql.com/doc
00:20 <****> hypnos22: G is the field to GROUP BY; O is the field to order by (the one of which you want the max per group);
00:21 <****> hypnos22: If O is not guaranteed to be unique per group, you can add a secondary ordering to that.
00:21 <****> hey all.... anyone knows a good application to convert a .sql file to diagram?
00:22 <****> errr. what?
00:22 <****> HI
00:22 <****> hi
00:23 <****> SELECT * from csm where Status=\'Active\' or Status=\'Scheduled\' and CSM_Type != \'Sales Lead\' order by Priority ASC << does not filter out Sales Lead :(
00:23 <****> got a pbm with Mysql on Ubuntu sys. May someone help plz?
00:24 <****> raden_work, check spelling, must be a user error and not a mysql issue from now on
00:24 <****> User442, try asking
00:24 <****> crystal ball is broken :(
00:24 <****> nope did it at console to wont filter all out
00:25 <****> just the Status filter with or works but I throw in the CSM_Type and its a gonner
00:25 <****> raden_work, precedence
00:25 <****> mind case sensitivity, and condition grouping
00:25 <****> thats what im thinking
00:25 <****> as I log with sudo -s, I still can't use with the console "mysql" : Access denied for root (using password NO..
00:26 <****> hmmmm
00:26 <****> how would I do this
00:26 <****> raden_work, you query will return 'Sales Lead' as long as Status=\'Active\'
00:27 <****> raden_work, usually this is solved with parentheses
00:27 <****> i switched it
00:27 <****> raden_work: WHERE (...) OR (...) AND (...); is not going to do what you expect, most likely.
00:27 <****> select * from csm where CSM_Type != 'Sales Lead' and Status='Active' or Status='Scheduled';
00:27 <****> worked
00:27 <****> hi I just want to confirm what I've read about using replication to back up a mysql db. Basically, you replicate the live db offsite to a slave db, and then do periodic dumps of the slave, which will not impact live's performance. Is this correct?
00:28 <****> this will output 'Sales Lead' so long as Status='Scheduled'
00:28 <****> raden_work: Learn to use ()'s to force order of execution.
00:28 <****> Xgc, thanks for the tip :)
00:29 <****> some body help with a innodb configuration i have a problems with the RAW support
00:29 <****> raden_work, so Xgc gets the thanks
00:29 <****> gnari, thanks for the help as well much appreciated
00:29 <****> everyone here got my brain ticking :)
00:29 <****> gnari, I must admit you were right : )
00:29 <****> of course
00:30 <****> hi
00:31 <****> Anyone have a few minutes to help out with a prepared statement/C issue?
00:31 <****> when i specific the tablespace type RAW for inndbmm when execute SHOW ENGINES; the innodb engine its DISABLE and hay seen the mysql error log and no errors in the file... some body help me ?
Total 24 pages. You are browsing page 1/24.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last