GROUP_CONCAT() use on query

SELECT * , GROUP_CONCAT(DISTINCT language.language SEPARATOR ', ') AS Sprachen FROM item_all_language LEFT JOIN item ON itemitem_identity = item.item_identity LEFT JOIN language ON languagelanguage_identity = language.language_identity GROUP BY item.titel; SELECT * , GROUP_CONCAT(CONCAT( author.s

RE: Streaming LOB Data

Thanks Sergei, it's nice to know for sure. Do you know if there is any documentation on how memory is used to store LOB data? For example, is it a percentage of the total buffer pool size or is it allocated from available memory un-allocated to the buffer pool size? -Original Message- Fro

Re: Streaming LOB Data

Hi! On Apr 28, Robert DiFalco wrote: > It appears (for InnoDB at least) that while INSERTing a LOB that all LOB > data must be loaded into memory before it is written to disk. Or is it > just the size of the combined log files? Looking at Task Manager, it > looks like it DOES try to load the whole

RE: Help with subqueries... MAX() and GROUP BY [sovled]

--- Daevid Vincent <[EMAIL PROTECTED]> wrote: > Well I think this is mostly working. I have a 'NULL' user ID which is > 'system' that I need to get into here, but I think I'm mostly on > track... > > There are lots of ways to accomplish this task it seems. ALL of which > would > be so much easi

Replication between Mysql 4.1.8-standard and MySql 5.0

Hi Comunity, I have a problem while configuring 'Replication'. My Master Database is MySql 4.1.8-standard version, and Slave is 5.0. I want to set Replication between them. Problem here is in MySql 4.1.8-standard version the 'user' table fields are Host, User, Password, Select_priv, Insert_priv,