Archive for December, 2011

MySQL Export to CSV File

Ever needed to export data from MySQL into a CSV file? Its actually fairly simple,

SELECT * INTO OUTFILE ‘/tmp/name.csv’
FIELDS TERMINATED BY ‘,’
OPTIONALLY ENCLOSED BY ‘”‘
ESCAPED BY ‘\\’
LINES TERMINATED BY ‘\n’
FROM [tablename]

Certainly easier then writing a quick Python/Perl/PHP script to do the job.

via MySQL Export to CSV File.

LifeHacker: Adjust Your Car Mirrors Properly To Avoid Accidents

Adjust Your Car Mirrors Properly To Avoid Accidents via LifeHacker

Many accidents could be avoided if everyone had their car side and rearview mirrors positioned correctly, eliminating blind spots and making it easier to change lanes quickly.