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

Tagged: 

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • September 29, 2015 at 9:17 am #35496
      maryam.dairkee
      Member
       

      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.html. That’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.
  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.