jb60606 Posted November 10, 2007 Share Posted November 10, 2007 I'm sure there is a simple answer to this, though I'm new to mysql. I have several several large numbers stored in a mysql database. Type 'int'. One number, for example, could be '12351'. Is there any simple way to change that to, say, 12.351? The problem is that I'm using these numbers in a combination bar/line chart. The bars represent these large numbers (which can range between 9,000 and 100,000), and the line (which overlays the bars) represent smaller numbers (ranging from 1 to 100). As a result, the line is almost straight wherein fact it's numbers are quite volatile. Thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/76762-large-numbers-in-mysql/ Share on other sites More sharing options...
Barand Posted November 10, 2007 Share Posted November 10, 2007 Or you could leave them as they are in the database and divide by 1000 prior to plotting them in the chart. Quote Link to comment https://forums.phpfreaks.com/topic/76762-large-numbers-in-mysql/#findComment-388726 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.