Currently viewing the category: "MySql"

MySQL export to csv

By On 10/10/2011 · Leave a Comment

SELECT id, name, email INTO OUTFILE ‘/tmp/result.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\n’ FROM users WHERE 1

@see http://dev.mysql.com/doc/refman/5.6/en/load-data.html

Continue Reading →

no such file to load — mysql

By On 21/06/2009 · Leave a Comment

from http://blogs.sun.com/divas/entry/no_such_file_to_load

Rails never fails me. As soon as I publish a series of tutorials for a NetBeans release, a new Rails release comes out which breaks my tutorials (and, apparently, most everyone else’s). Gratefully, some customers took the time to click the Feedback button at the end of our tutorials to let us [...]

Continue Reading →