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;
CSV Export from MySQL Command line (Windows/Linux)
- No comments yet.
Flexicoder Blog- Freelancing – Work Sources January 9, 2013Now that I’ve started thinking more about my life as a freelancer I’ve been looking at where my work comes from and what sort of skills I’m being asked to use. The following is a simple breakdown of that data from Jul 09 to Dec 12. But first a brief bit of history… I’ve been […]
- Contract or Freelance – PROS/CONS January 2, 2013Here are my small nuggets of wisdom regarding contract/freelance (as I see them) Contracting – PROS It should be relatively easy to find a contract if you have a good skill set, look at jobserve.com or cwjobs.co.uk – the rates do vary quite a bit Once you have a contract its guaranteed income for the […]
- WWDC 2012 Songs June 16, 2012Here is a list of the songs that I heard in between sessions at the WWDC No You Girls – Franz Ferdinand – Houdini – Foster The People – Someone Great – LCD Soundsystem – 11th Dimension – Julian Casablancas – Man On Fire – Edward Sharpe & The Magnetic Zeros – My Doorbell – […]
- WWDC 2012 – Post Mortem June 16, 2012WWDC As always at the WWDC there is a lot going on and a lot of information to try to digest to make the trip worthwhile. But this year there also appeared to be a lot more attendees than the last 2 times I’ve been, which lead to a lot of queuing! It took a […]
- WWDC2012 – How Did My Predictions Score June 16, 2012Before I went to WWDC I came up with the following wish list of improvements/features that were hopefully going to be announced this year… Ability to run apps on the Apple TV and use your iOS device as a controller, including multiple devices at the same time Open up Siri to 3rd party apps, although […]
- WWDC 2012 – Apple TV Apps May 10, 2012I’m lucky enough to be attending the WWDC this year, as it reaches closer to the “day of the long queue” my thoughts are turning to what I hope will be announced at the conference. So here they are in no real order (apart from the first one) Ability to run apps on the Apple […]
- Freelancing – Work Sources January 9, 2013