Query headaches

x27;m thankful for every tip I can get, and please let me know if you want to see the table layouts. Best regards -- Kim Christensen "With insomnia, you're never really asleep; you're never really awake." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Insane execution time for JOIN query

On 8/31/06, Harrison Fisk <[EMAIL PROTECTED]> wrote: Hello, On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote: > Hey list; > > I posted this message under an earlier thread which touched the same > subject - but I realized my case could be slightly different, thus > post

Re: Insane execution time for JOIN query

| | read_rnd_buffer_size| 262144 | | sort_buffer_size| 2097144 | +-+--+ The box has 1GB of physical RAM and 2GB in one swap partition. Thanks for the help so far! -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mys

Re: Insane execution time for JOIN query

hanged from default. - Original Message - From: "Kim Christensen" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Thursday, August 31, 2006 5:12 AM Subject: Insane execution time for JOIN query > Hey list; > > I posted this message under an earlier thread

Insane execution time for JOIN query

d | varchar(45) | NO | MUL | || | item_description | varchar(255) | NO | | || | item_weight | float| NO | | 0 | | +--+--+--+-+-++ Best regards -- Kim Christens

Lazy and greedy control statements

then process it with my programming language of choice? :-) Best Regards -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BOOLEAN search with asterisk as preceeding operand?

ends with . I guess I'm not alone to have this "problem" ;-) Regards -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: GROUP_CONCAT returns BLOB

On 6/21/06, Kim Christensen <[EMAIL PROTECTED]> wrote: Hey list; I'm having trouble with the GROUP_CONCAT() function, which (according to the docs) is supposed to give me a column with the VARCHAR type, unless group_concat_max_len is >512. Instead it BLOBs me! Hmm, I just reali

Re: GROUP_CONCAT returns BLOB

On 6/21/06, Kim Christensen <[EMAIL PROTECTED]> wrote: Hey list; I'm having trouble with the GROUP_CONCAT() function, which (according to the docs) is supposed to give me a column with the VARCHAR type, unless group_concat_max_len is >512. Instead it BLOBs me! Hmm, I just reali

GROUP_CONCAT returns BLOB

7; Any ideas? (Sorry if this is a double-post, I accidently sent the first message from an unsubsribed address) -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

GROUP_CONCAT returns BLOB

x27;t be different from the default value, but the strange thing is that the same function returns a VARCHAR column when used on another table - they are both MyISAM tables. Here's the query in question: SELECT GROUP_CONCAT(product_id) FROM products WHERE product_retail_id LIKE '%dfl-%&

Re: order field of a table

7;re not on top (importance 0). ...just realize this might get you more confused than clearing it out for you, but what the hey. Best regards -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can i decrypt password

ich crypt method you are using for the passwords. -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Limiting results from joins

e matching - on all the rows (huge execution time) - how can I prevent this? MVH -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Limiting results from joins

On 6/12/06, Barry <[EMAIL PROTECTED]> wrote: Kim Christensen schrieb: > Hey list; > > Consider this statement: > > SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id > = m.manufactor_id && p.product_id = i.product_id; > > Now, each uniq

Re: Limiting results from joins

On 6/12/06, Barry <[EMAIL PROTECTED]> wrote: Kim Christensen schrieb: > Hey list; > > Consider this statement: > > SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id > = m.manufactor_id && p.product_id = i.product_id; > > Now, each uniq

Limiting results from joins

i WHERE p.manufactor_id = m.manufactor_id && p.product_id = i.product_id && i.item_id = (SELECT item_id FROM items i2 WHERE i2.item_updated = 1); I find the above solution VERY slow, almost as if I have missed out on a very fundamental part of the logic - but it does get the work done. Ho

Re: A complex JOIN scenario

ve Works like a charm, thanks! -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A complex JOIN scenario

:-) Yeah, I guess a FULL one is exactly what I think I'm looking for. Still can't work the query out though, since both columns have different column lengths MySQL is complaining - I need to know how to NULL the non-existant table columns for the rows that doesn't have any values

Re: A complex JOIN scenario

1038 | 63 | 1144744655| 777 | ++--+-+---+---+ I hope this helps, sorry for being short on information but I haven't really woken up properly yet. More coffee.. -- Kim Christensen [EMAIL PROTECTED] -- MySQL General

Re: A complex JOIN scenario

derstand from this example above, each "invoice_id" > > is only present in one of the tables, therefore the NULL values. > > > > How can I accomplish something like this? > > See above. > > Martijn Tonies > Database Workbench - development tool

A complex JOIN scenario

this example above, each "invoice_id" is only present in one of the tables, therefore the NULL values. How can I accomplish something like this? -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: User is rejected because of IP, but hostname is allowed

On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote: > Nope. Well, have you tried it? Did it solve your problem? -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: User is rejected because of IP, but hostname is allowed

On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote: > Nope. Well, have you tried it? Did it solve your problem? -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Creating REGEXP patterns with use of subquery

set of rows which "parent" columns matches 5. I would like to use all these results in the last REGEXP query example above, something like this: SELECT * FROM table WHERE value REGEXP '^\\[(SELECT id FROM items WHERE parent=5)' Anyone got any clues? -- Kim Christensen [EMA