Archive for May, 2012

CSV Export from MySQL Command line (Windows/Linux)

select col1, col2, col3
INTO OUTFILE 'c:/dump.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
from tblA a inner join tblB b on a.col1 = b.col2;

No Comments

Highcharts- Highlight the last clicked bar

This is handy, only really if you have charts which, on click, have drill down data which pops up, perhaps in a table underneath or something- I basically just wanted to highlight the last clicked column in a column chart;

Check it out on jsFiddle : http://jsfiddle.net/shawson/CkkbF/8/

2 Comments