MadTechie Posted April 10, 2007 Share Posted April 10, 2007 OK this should be simple but again i have messed up somewhere, i have review my "O'Reilly's MySQL Pocket Referance.. :-\" but its not much help.. OK the problem Table1 Field A Field B Field C All Type Float Now Field A = 140 Field B = 211 Field C = 0 i run the SQL statement UPDATE `Table1` SET `Field C` = ((`Field A`/`Field B`)*100 ); and Field C becomes ...150.714... surely that shoud be 66.666.....? can someone please help me workout what i am doing wrong.. Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted April 10, 2007 Share Posted April 10, 2007 I get 66.3507 as the result. When I run the above query on a test table I set up. What data types do you have set? fieldA and fieldB should be INT and fieldC should be FLOAT Quote Link to comment Share on other sites More sharing options...
MadTechie Posted April 10, 2007 Author Share Posted April 10, 2007 Field A and B may need to be Floats, Strange i just created another table and it works but the old table still fails.. i am trying to work out why! Will try to rebuild the old table, if it fails i'll post it OH one other thing, the Fields used in this calculation were Text but i converted them (before trying the calculation) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.