Hi,
I've got the exact same problem than Johannes with MySQL 4.1.14.
Like him, i've set a little script
[EMAIL PROTECTED]($host,$user$password);
while ($i5) {
$x=mysql_query($query);
if ( $x) {
print $i worked!BR;
} else {
print $i ERROR! .mysql_error().BR;
}
$i++;
}
Why when I do select from database and try to compare float field with float
number, I have no results
amount --- type float
select * from price where amount = 3.45 // doesn't work
select * from price where amount = '3.45' //doesn't work
select * from price where amoun like '3.45' //work
My
Hi
I have 2 tables, say A and B. One field in table A, say A_link, points
to a field B_link in table B. I need to select entries in A, which
fulfill two conditions: A_cond1 = XX and B_cond2 = YY.
E.g
tabel A table B
A_cond1 A_link B_link B_cond2
1
Jerry Swanson [EMAIL PROTECTED] writes:
Why when I do select from database and try to compare float field with float
number, I have no results
amount --- type float
select * from price where amount = 3.45 // doesn't work
select * from price where amount = '3.45' //doesn't work
Floating
Scott Gifford wrote:
select * from price where amount = 3.45 // doesn't work
Floating point numbers are very rarely equal, because of small
rounding errors that happen all the time. Probably the actual number
in the database is something like '3.44001'.
Try something like
Hi all,
Anybody has worked as a developer to MySQL Database Server features?
Thank you
Fabricio Mota
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
