MySQL wrote:
You might also consider using two integer type fields - one for the
numerator and another for the denominator. This way storage and recovery are
easy and the mathematics are wide open.
_M
I suspect that a float add is faster than 3 integer multiplies and
sum.
It
From: MySQL [EMAIL PROTECTED]
From: Madscientist [EMAIL PROTECTED]
You might also consider using two integer type fields - one for the
numerator and another for the denominator. This way storage and recovery are
easy and the mathematics are wide open.
_M
I suspect that a float
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
X-Sender: [EMAIL PROTECTED]@teton.kitebird.com
Date: Thu, 19 Sep 2002 08:54:55 -0500
From: Paul DuBois [EMAIL PROTECTED]
News-Group: list.mysql
Reply-To: [EMAIL PROTECTED]
At 20:47 -0500 9/18/02,
PM
]To: [EMAIL PROTECTED]
]Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
]Subject: Re: Fractions
]
]
] Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
](http://www.ezmlm.org)
] X-Sender: [EMAIL PROTECTED]@teton.kitebird.com
] Date: Thu, 19 Sep 2002 08:54:55 -0500
] From: Paul DuBois [EMAIL
multiplies and
sum.
]-Original Message-
]From: MySQL [mailto:[EMAIL PROTECTED]]
]Sent: Thursday, September 19, 2002 7:51 PM
]To: [EMAIL PROTECTED]
]Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
]Subject: Re: Fractions
]
]
] Mailing-List: contact [EMAIL PROTECTED]; run
At 20:47 -0500 9/18/02, William Martell wrote:
Hello.
Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
data representing different lengths of objects measured in inches. Can I
load this data as is into a field in MySQL or do I have to convert it first
into an floating
you could store them as 3 integers. The integral part, the numerator of
the fraction and the denominator of the fraction - then interpret them
at the client side.
William Martell wrote:
sql,query,database,odbc
Hello All,
Can anyone tell me whether I can represent fractions in MySQL
On Wed, 18 Sep 2002, William Martell wrote:
Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
data representing different lengths of objects measured in inches. Can I
load this data as is into a field in MySQL or do I have to convert it first
into an floating point
[ this mysql spam filter sucks -- including a query in one's message
isn't good enough ]
[EMAIL PROTECTED] wrote:
you could store them as 3 integers. The integral part, the numerator
of the fraction and the denominator of the fraction - then interpret
them at the client side.
This