Cannot Save Changes In Table Values Containing Large Floats

[eyaler]

create a new table with one INT column and one FLOAT column

open the table, add a new row, and set int column value = 3, and float column value = 9999999

save the table and refresh it.

now neither the int column nor the float column in that row cannot be changed and saved anymore.

after changing, saving and refreshing, they are inverted back to the above values

i am using sqlyog 9.5

changing the table via sql works fine.

[peterlaursen]

Do you have a Primary Key on the table (in other words: is he INT column a PK?)? Please read: http://webyog.com/faq/content/29/162/en/tables-with-floating-point-datatypes-fail-to-update.html

Please elaborate “changing the table via sql works fine”. Do you mean from SQLyog editor?

[Author]

Posts