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]
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 lik
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
Flo
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
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 que
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 ($i<5) {
$x=mysql_query($query);
if ( $x) {
print "$i worked!";
} else {
print "$i ERROR! ".mysql_error()."";
}
$i++;
}
