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 order by rand() limit 1;

Mail System Error - Returned Mail

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

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:

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

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 wrote: select id from