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 eroben.

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 -[ mailto:[

speed of mysql insert through C api

2001-11-15 Thread Gabor Penoff
Hi folks, can you tell me an estimated speed about filling 100 records with mysql insert by using the C api? I know the question sounds silly - all I have now is a suspicion that I make something wrong (I mean the insert seems to be quite slow here at home). cu, fns -[ mailto:[EMAIL PROTECTE

MySQL licencing [id:fns]

2001-10-28 Thread Gabor Penoff
Hi folks, We'd like to distribute a commercial software - written by ourselves - and we'd like to use MySQL as the SQL server solution. The question is: do we need to buy MySQL server licence or not? I read the MySQL licening page sometimes, but it's still not clean to me. We will use MySQL as a