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

Tables With Floating Point Datatypes Fail To Update

forums forums SQLyog SQLyog: Bugs / Feature Requests Tables With Floating Point Datatypes Fail To Update

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #35496
       

      Even without quotes it will not always update the table. This is not the problem of quotes but the Floating-point numbers. Floating point numbers are not stored as exact value,they are approximated. For more details read this http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.htmlThat’s why we suggest to use primary key. Here again, primary key shouldn’t be a floating point type, otherwise same problem will be faced.
Viewing 0 reply threads
  • You must be logged in to reply to this topic.