RE: Multiple sums in a single select?

You can use an IF in a SUM if you add them based on special conditions: e.g.: SUM(IF(field = 1, field_to_sum, 0)) -Original Message- From: Kendall Bennett [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 14. April 2005 23:55 To: mysql@lists.mysql.com Subject: Multiple sums in a single select

RE: Problem: Too many connections

Back to the original problem ;) Please post your my.cnf. -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED] Sent: Samstag, 12. März 2005 16:02 To: mysql@lists.mysql.com Subject: Re: Problem: Too many connections At 01:25 AM 3/12/2005, sapna murari todwal wrote: >Hi, >I ha

RE: Query_cache_size Question

Depends on the result sets you want to cache. Check the other variables in the manual, you can analyze if all the query cache is utilized at a point in time. In general 16M is low when you have 4GB, you can safely increase it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PRO

AW: extracting ddl

Hi, All MySQL server installations ships with some client tools. Try executing the following statement on your server mysqldump -uUSERNAME -p DATABASENAME > dump.sql After this operation "dump.sql" will include all information needed. The information can be loaded into another server issuing

AW: connection problem with 4.1.7

Hi, When you have this problem, do the MySQL client applications work? Have you tried logging in with the mysql client? Kostas -Ursprüngliche Nachricht- Von: P.V.Anthony [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 6. November 2004 02:36 An: [EMAIL PROTECTED] Betreff: connection proble