tag:blogger.com,1999:blog-20434908.post7812083108808871042..comments2023-12-10T07:15:30.512-08:00Comments on Rational Relational: How to Quickly Create a Histogram in MySQLUnknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-20434908.post-66288121060982833752023-12-10T05:01:09.350-08:002023-12-10T05:01:09.350-08:00nice ! Thanks!nice ! Thanks!alexeyvvhttps://www.blogger.com/profile/07186067382689339258noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-64964471290777627502019-07-21T15:01:13.842-07:002019-07-21T15:01:13.842-07:00thumbs up!thumbs up!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20434908.post-84846669810436992622019-01-28T21:37:10.759-08:002019-01-28T21:37:10.759-08:00You know what you saved my life thank you very muc...You know what you saved my life thank you very much.<br />Jane Kathambi Igokihttps://www.blogger.com/profile/04401039449541291152noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-47607618526833113452013-09-28T21:57:48.227-07:002013-09-28T21:57:48.227-07:00Wow. I'm really impressed by this, and it came...Wow. I'm really impressed by this, and it came in really handy just now. Thanks for posting it!Anonymoushttps://www.blogger.com/profile/17329231659528132471noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-3606402987076644402012-05-22T20:05:20.867-07:002012-05-22T20:05:20.867-07:00No need to include the `bar` column—the `count` co...No need to include the `bar` column—the `count` column already forms a logarithmic histogram! Look carefully at the example in the post: the shape of the `count` column is a mirror image of the `bar` column. This happens because the number of digits in a positive integer N is CEIL(LOG10(n)).<br /><br />If you want to make it a linear histogram, just do EXP(COUNT(*)) instead.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20434908.post-7939191842247666722012-03-14T19:18:56.038-07:002012-03-14T19:18:56.038-07:00Super smart. I didn't know you could round to ...Super smart. I didn't know you could round to a negative digit, makes perfect sense though!PsySalhttps://www.blogger.com/profile/03334292849719348870noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-20356813420943799972011-08-17T04:08:37.763-07:002011-08-17T04:08:37.763-07:00You're welcome!
A funny thing I've though...You're welcome!<br /><br />A funny thing I've thought about after publishing - the stars and numbers look very symmetrical. Thing is, I can make them completely symmetrical by using LOG10 instead of LN :)shlomoidhttps://www.blogger.com/profile/08509735030020026930noreply@blogger.comtag:blogger.com,1999:blog-20434908.post-30312303702524738322011-08-16T12:43:37.048-07:002011-08-16T12:43:37.048-07:00Awesomeness, thanks for sharing!
Sometimes just k...Awesomeness, thanks for sharing!<br /><br />Sometimes just knowing that something is possible makes your life easier - I might have assumed this wasn't possible without a lot of effort, so the thought to Google for it wouldn't have entered my mind. Now, I won't remember how to do it, but I'll remember it's possible, and will be able to find your post.ripper234http://ripper234.comnoreply@blogger.com