#mysql
05 November 2007
Total 21 pages. You are browsing page 5/21.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
03:56 <****> smtlaissezfaire: it tells you how many person has the same first name
03:56 <****> I'm curious both: a) how it is generally useful, and b) if it would help to solve my original problem with distinct
03:57 <****> smtlaissezfaire: You might not. But it's a common operation used to produce sets and to extract aggregate information.
03:57 <****> Xgc: I'm trying to figure out this error: http://rafb.net/p/iewhYe63.html
03:58 <****> smtlaissezfaire: What if you want to find the minimum age for all users named Bob?
03:58 <****> smtlaissezfaire: What if you want to find the minimum age for all users with the same name?
03:58 <****> sqlnoob: so many derived table, each derived table needs an alias
03:58 <****> Xgc: I'm assuming is the "AS v1 ON" part.. but I dont understand why do I have to have 2 "AS v1" for the same sub-queries in one big query query
03:59 <****> Xgc: should I use v2 instead of v1 for the 2nd subquery?
03:59 <****> sqlnoob: Construct a larger query with aliases that make sense.
03:59 <****> sqlnoob: I'm not telling you what names/aliases to use.
03:59 <****> Xgc: a larger query than that???
04:00 <****> sqlnoob: Larger than you normally have.
04:00 <****> sqlnoob: While you can use v1 several times in the same SQL, you might not want to do that.
04:00 <****> sqlnoob: ORDER BY month_count).. 1 more alias here..) AS v1
04:00 <****> sqlnoob: or you might want to use a more meaningful name/alias.
04:00 <****> Xgc: i put v2 but i still get the same error...
04:01 <****> sqlnoob: yuo need 1 alias for each derived table, you are missing 1
04:01 <****> sqlnoob: Well, some number of posts ago, you had an obvious error. You keep changing the mistake.
04:01 <****> sqlnoob: I can't keep up with the new mistakes. You don't seem to be focusing on one problem at a time.
04:01 <****> hello
04:01 <****> kimseong: ok let me try figure out which one..
04:02 <****> folks, I have a mysql dbms installed on a remote server
04:02 <****> Xgc: i'm confused, that's why.. sorry
04:02 <****> and a client/server app that need to conect to this db
04:02 <****> sqlnoob: About 2 or 3 posts ago, you were close to a solution.
04:02 <****> however, even though I can connect through localhost there in this server
04:02 <****> any attempts to connect from other hosts fail
04:02 <****> what should I do?
04:02 <****> !m FFighter grant
04:02 <****> FFighter: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/grant.html
04:03 <****> Xgc: ok how about i put the latest and you tell me how bad it is?
04:03 <****> Xgc, etc: Thanks for the help. I may see you guys later.
04:03 <****> Xgc: ok here: http://rafb.net/p/MEGsmd71.html
04:03 <****> sqlnoob: Thanks, what is the syntax for wildcard (all hosts)?
04:04 <****> FFighter: it can be found in the url
04:06 <****> how can I assign a user permissions to creat a database in the dbms?
04:08 <****> only root can create databases?
04:12 <****> anyone? im running out of ideas...
04:18 <****> how can I export just the table schema
04:18 <****> without the data
04:23 <****> elo
04:27 <****> is there a way to force mysql to use a certian processor core (or should be in in #linux for that)
04:29 <****> i think i finally got it jeez that was hard!
04:30 <****> sqlnoob: You should have probably followed my initial form a little closer. Post yours to the pastebin. Let's see how much it differs from that.
04:31 <****> Xgc: i got it working =) but i get the number i need to change the v1.* for soemthing so it prints the month's name and count instead of number
04:32 <****> sqlnoob: Well, you used MONTHNAME(), didn't you?
04:32 <****> Xgc: here is the new code working: http://rafb.net/p/hk9jQ762.html
04:33 <****> sqlnoob: If you just wanted the month number, change MONTHNAME() to MONTH().
04:33 <****> Xgc: no, no I want the name.. im fixing it right now, lets see if it works
04:34 <****> Xgc: yeah working lovely.. thanks a lot Xgc..
04:35 <****> sqlnoob: Your current SQl uses MONTH() in v2.
04:35 * Xgc nods.
04:37 <****> sqlnoob: Looks good and the suggested form.
04:37 <****> hi
04:37 <****> Xgc: I owe u big I don't think i could've done it alone
04:38 <****> sqlnoob: The first few like this are the toughest. You'll get used to it.
04:40 <****> sqlnoob: Suggestion. Move the ORDER BY to the outer most select, otherwise your final ordering won't be guaranteed.
04:41 <****> Xgc: "Suggestion" isn't a complete sentence.....
04:41 <****> s/./:/
04:43 <****> Xgc: you mean order by from 1st subquery or 2nd subquery??
04:43 <****> sqlnoob: The ORDER BY clauses in the derived tables are not useful.
04:44 <****> sqlnoob: Remove them and add an order by for the outer-most select.
04:45 <****> sqlnoob: ORDER BY v2.month_count DESC -- just this one for the outer-most select.
04:45 <****> Xgc: ahhhhhhh ok i see what you're saying let me try and show you the final result
04:45 <****> I am having an issue with using prepared statements via the C api
04:46 <****> I thought I had everything correct, although it seems to crash when i attempt to execute the statement
04:46 <****> the last frame in the backtrace is store_param_int32()....
04:46 <****> fuse_lt: That's expected behavior for C.
04:46 <****> Now, I've run through the code and checked the BIND and the STMT structs and everything seems to have prepared correctly, but I am not sure where I may have gone wrong.
04:47 <****> Any advice would be helpful.
04:47 <****> Xgc: seems that way :-)
04:47 <****> Xgc: yeah but it doesnt seem to like that im putting that between a ON and an IN
04:47 <****> fuse_lt: A full compilable testcase is probably necessary. There's no easy way to guess where your bad pointer or buffer overrun is.
04:48 <****> sqlnoob: Insert before the semicolon.
04:48 <****> ok
04:48 <****> how do I see what the definition of a table is?
04:48 <****> sqlnoob: The ORDER BY is the last clause in your entire statement.
04:49 <****> SiliconG: show create table tblname;
04:49 <****> Xdc: works beautiful ^^ thanks!
04:49 <****> sqlnoob: No problem.
04:50 <****> Xgc: as a side note.. do I really need that sort by?
04:51 <****> sqlnoob: No. That was your idea.
04:52 <****> Xgc: it was??? lol ok.. well then i dont think i need it.. cause all i care is to display highest and lowest
04:53 <****> hi
04:54 <****> sqlnoob: I think you included it from the original form that used ORDER BY to find the min and max.
04:54 <****> guys, how can i select a value that belongs to a list? there should be something like `id` in (1,2,3,4) what is the exact syntax?
04:55 <****> EGBlue: what you said, IIRC
04:55 <****> is that the correct syntax?
04:55 <****> looks like it
04:55 <****> ok great, thanks
04:56 <****> Xgc: Hey - could I bug you again about group by?
04:56 <****> imMute, and if i want it to be excluded from the list i say `id` NOT IN (1,2,3,4) ?
04:56 <****> EGBlue: no idea
04:57 <****> hah, ok thanks ;)
04:59 <****> smtlaissezfaire: Of course. Ask.
05:00 <****> is there a way to compare a table in one database to another in a different one to make sure the data would move
05:02 <****> hm
05:02 <****> SiliconG: Compare in what way? SELECT .. FROM dbname.tblname JOIN dbname2.tblname2 ON ...;
05:03 <****> SiliconG: To compare the structure or the data/
Total 21 pages. You are browsing page 5/21.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last