Query headaches

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 posting a new thread here. Sorry

Insane execution time for JOIN query

| float| NO | | 0 || +--+--+--+-+-++ Best regards -- Kim Christensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Insane execution time for JOIN query

from default. - Original Message - From: Kim Christensen [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com 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 which touched the same subject

Re: Insane execution time for JOIN query

| | 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.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Lazy and greedy control statements

and 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]

GROUP_CONCAT returns BLOB

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-%' Any ideas? Regards -- Kim

GROUP_CONCAT returns BLOB

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]

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 realized this won't

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 realized this won't

BOOLEAN search with asterisk as preceeding operand?

, and ends with keyword. 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: order field of a table

importance X importance 0 Which would move all the employees which were under the given employee (with importance X) up a step, as long as they'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

Re: How can i decrypt password

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]

Limiting results from joins

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. How could I speed this up, or solve it in another statement? Regards -- Kim Christensen

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 unique product_id from products can have more than one

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 unique product_id from products can have more than one

Re: Limiting results from joins

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]

A complex JOIN scenario

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: A complex JOIN scenario

://www.databasedevelopmentforum.com -- 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

| ++--+-+---+---+ 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 Mailing List For list archives: http

Re: A complex JOIN scenario

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 for them. Any hints? ;-) -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: A complex JOIN scenario

On 4/11/06, Santino [EMAIL PROTECTED] wrote: I do not try it : select invoice_id, order_id, customer_id, invoice_timestamp, invoice_total, null from invoice union all select invoice_id, null, null, null, null, invoice_journal_id from invoice_archive Works like a charm, thanks! -- Kim

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

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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe