SubscribeHome About Us

MySQL Bar Chart from the Command Line

by John Coronella, May 5th, 2009

MySQL Command Line Bar Chart

MySQL Command Line Bar Chart



I just ran accross this really cool method of generating a bar chart from the mysql command line using the mysql repeat command:



mysql> select date_format( create_time, '%Y-%m-%d') dt, repeat( '#', count(id)/20.0+1) dt from result group by dt;

Comand line stats are addictive. Nothing like real time… enjoy. Thanks to snipplr.

Comments Off

This entry was posted on Tuesday, May 5th, 2009 at 8:57 am. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.

P