Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Problem With Behaviour Of Float Fields

forums forums SQLyog Using SQLyog Problem With Behaviour Of Float Fields

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #21422
      TomBez
      Member

      have a look at: http://dev.mysql.com/doc/refman/5.1/en/pro…with-float.html

      the problem is, that stored float values differ somehow, so try something like:

      Quote:
      select * from tablename1 where float_>'0.12345' and float_<'0.12346';

      (this only helps you view the data, but not the handling with sqlyog)

    • #21423
      larsen
      Participant

      ok, I see.

      thx =)

    • #21424
      peterlaursen
      Participant

      The solution is to have a Primary Key in the table. Then SQLyog will ONLY use this this PK in the where-clause.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.