Question: I want to grab data from SQL database and show it in csv file.
Answer:
SELECT * INTO OUTFILE '/tmp/out.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM myTable;
More: MySQL manual
Credit: nyem at lowyat.net
XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="">
My name is Charles Peter and I am Asian and my English sucks. Information Technology (I.T) is great for people who afraid getting bored. ‘Boring’ is expensive but in I.T, it’s cheap. What you know today, will be invalid tomorrow. That’s I.T.
In this web log, it’s all about snippets of unsolved or solved I.T issues either by Harold & Kumar or Google. If you think this web log is boring, fuck you!
No comments
Jump to comment form | comments rss [?] | trackback uri [?]