GROUP by multiple columns [id:fns]

2002-03-12 Thread Gabor PENOFF
Hi folks, I need a select groupped by more than one field like: SELECT a, b, c, SUM(d) FROM a GROUP BY CONCAT(a,b) - but it doesn't work (MySQL 3.22). Is it poissible somehow? cu, fns -[ mailto:[EMAIL PROTECTED] http://www.megaram.hu/~fns icq:878397 ]- -[ Zavart erzek az

Re: speed of mysql insert through C api

2001-11-16 Thread Gabor Penoff
On Thu, 15 Nov 2001, Jonothan Farr wrote: There's no way to know that without knowing the schema of the table you're inserting into. How you index it is going to be the biggest factor there. just a plain file with 2 columns - one of them is a decimal field - taht's all. cu, fns -[