PGメモ

非エンジニアの記録

csv

How to convert plist to CSV

I took so much time to solve this problem, that's why I note here.At first, I tried to find solution using Xcode or some command, however I couldn't. So, I changed to take another way; using web service.1. Convert plist to JSON http://json…

mysqlのデータをcsvで出力する方法

mysqlに入り、DBを選択した後 select * from hoge INTO OUTFILE "tmp/fuga.csv" FIELDS TERMINATED BY ',' enclosed by '"' lines terminated by '\r\n';これでcsvとしてファイルが書き出される もし Access denied for user 'xxx'@'localhost' (using passw…