Hi, Please read http://www.mysql.com/doc/en/Problems_with_float.html
It is a common problem when working with floating point numbers Dobromir Velev [EMAIL PROTECTED] ----- Original Message ----- From: "Octavian Rasnita" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 10:34 Subject: Is it normal? > Hi all, > > I've tried the following SQL queries: > > mysql> create table test(id float); > Query OK, 0 rows affected (0.00 sec) > > mysql> insert into test values(1.123), (3.1495); > Query OK, 2 rows affected (0.01 sec) > Records: 2 Duplicates: 0 Warnings: 0 > > mysql> select * from test where id=1.123; > Empty set (0.00 sec) > > Shouldn't this last query show me the record that has the id=1.123? > > What query should I use to do this? > > Thank you. > > > > Teddy, > Teddy's Center: http://teddy.fcc.ro/ > Email: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php