[AccessD] OT: Sum in MySQL

Hi Paul

None of those work for me.

Several admin tools are available. I use "MySQL Control Center" by "MySQL & Jorge del Conde". Should be a free download.

/gustav

>>> paul.hartland at isharp.co.uk 24-11-2005 16:07 >>>
Not sure about MYSQL, but off the top of my head I think I would use
something like the following in SQL Server

SELECT SUM(CAST([FieldInteger] AS Float)) FROM tblTable

Or possibly 

SELECT SUM(CONVERT(Float, [FieldInteger])) FROM tblTable

If it works, let me know as I want to start getting into MYSQL....In fact if
anyone knows if and where a good front-end for MYSQL exists (hopefully
similar to Enterprise Manager) then could you let me know.

Paul Hartland

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 24 November 2005 14:52
To: accessd at databaseadvisors.com 
Subject: [AccessD] OT: Sum in MySQL

Hi all
I recall we have some MySQL gurus around ...

If you have a field of datatype Integer (Long in Access) and wish to sum
this from a large amount of records, how would you do in MySQL?

In Access you would do something like:

  SELECT SUM(CDbl([FieldInteger])) FROM tblTable ...;

and the result would be a - potentially very large - Double.
What to use for CDbl() in MySQL?

/gustav