Skip to content

Instantly share code, notes, and snippets.

@rike422
Created September 30, 2014 14:11
Show Gist options
  • Save rike422/f365759f28f7606c5750 to your computer and use it in GitHub Desktop.
Save rike422/f365759f28f7606c5750 to your computer and use it in GitHub Desktop.
skypeから引っこ抜くやつ
echo ' SELECT chat.friendlyname, ms.timestamp, ms.author, ms.body_xml, ms.from_dispname FROM Messages as ms LEFT JOIN Chats as chat ON ms.chatname = chat.name;' | sqlite3 -csv main.db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment