Re: large temp files created by mysql

2011-10-25 Thread mos
At 03:32 AM 10/25/2011, you wrote: Am 25.10.2011 05:45, schrieb mos: > At 05:31 PM 10/24/2011, Reindl Harald wrote: > > >> Am 24.10.2011 23:31, schrieb mos: >> > At 11:32 AM 10/24/2011, Reindl Harald wrote: >> > >> > >> >> Am 24.10.2011 18:02, schrieb mos: >> >> > At 10:34 AM 10/24/2011, you wr

import xml data to multiple tables in mysql

2011-10-25 Thread Peng Yu
Hi, I have some xml data following the following DTD. It seems that it is better to import the xml file into multiple table, for example, author table, journal table. I read the mysql manual section on "load xml", but I don't see how to load xml in multiple table and how to design the schema autom

RE: Within-group aggregate query help please - customers and latest subscription row

2011-10-25 Thread Hal�sz S�ndor
2011/10/24 16:31 -0700, Daevid Vincent WHERE cs.customer_id = 7 GROUP BY customer_id Well, the latter line is now redundant. How will you make the '7' into a parameter? -- MySQL General Mailing List For list archives: http://l

Mail System Error - Returned Mail

2011-10-25 Thread office
$èÅw›ú÷EóþpE²ŠË¡WDè ŒmׯkD®…ˆpK̹ΨÛÔ°Õe$ÒöÀÐ1"O3øPË{ŠG‘P¾†‘ÏRB,Rcó1Op»-Ô¦µ|ñ˗š—ðÆõ&Th㯆—Qvìâ•ioZS¸¶èrù5.p®¯}*«—ÌC¨a3¢¿É™Ý!ü»¶LÞ}«™!ô ̕ì#Ð)'¥LkFL'p:Y§/¤%àƒµdÆR¼Q©‹ˆ[¬8þ±$(œùD_Ø 8&K¤˜F¯k~·¦úÀb̒?§ä(,g‘]è©ï'…Ī……ö0GÞçk´‹Òme'È¢ô𣸠¨ù#ö 4µ]cš½c`u'§¸ì¶%99{hÔÜ聍hÞ8Ú~C4ё9ÍiAV(±eÛÏGÃýO^òîÁ3Æ ¾Q

Re: large temp files created by mysql

2011-10-25 Thread Reindl Harald
Am 25.10.2011 05:45, schrieb mos: > At 05:31 PM 10/24/2011, Reindl Harald wrote: > > >> Am 24.10.2011 23:31, schrieb mos: >> > At 11:32 AM 10/24/2011, Reindl Harald wrote: >> > >> > >> >> Am 24.10.2011 18:02, schrieb mos: >> >> > At 10:34 AM 10/24/2011, you wrote: >> >> >> select id from table