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 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. Link to comment https://forums.phpfreaks.com/topic/76762-large-numbers-in-mysql/#findComment-388726 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.