Script47 Posted December 25, 2013 Share Posted December 25, 2013 (edited) How do you store numbers with points in a PMA table. So what data type do I use? I figured out how to do it, you have to use double. For some reason decimal didn't work (which I thought it would be because of the name). If anyone knows why it didn't work, please post as it would clear up and will help me and other too. Edited December 25, 2013 by Script47 Quote Link to comment Share on other sites More sharing options...
Guest Posted December 25, 2013 Share Posted December 25, 2013 decimal? m2s Quote Link to comment Share on other sites More sharing options...
Script47 Posted December 25, 2013 Author Share Posted December 25, 2013 decimal? m2s I tried that, however when I then put a number like 1.2, it will automatically change to 1, any ideas why? Quote Link to comment Share on other sites More sharing options...
Guest Posted December 25, 2013 Share Posted December 25, 2013 Do you have decimal (1, 5)? http://stackoverflow.com/questions/6525180/mysql-decimal-with-accuracy-of-10-digits-after-the-comma Quote Link to comment Share on other sites More sharing options...
Script47 Posted January 2, 2014 Author Share Posted January 2, 2014 Do you have decimal (1, 5)? http://stackoverflow.com/questions/6525180/mysql-decimal-with-accuracy-of-10-digits-after-the-comma Sorry, forgot to say, this link helped me fix it. Thanks. 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.