Cacher is the code snippet organizer for pro developers

##Android SQLite

*驗證與除錯CMD指令
(https://litotom.com/2016/05/09/android%E9%AB%98%E6%95%88%E5%85%A5%E9%96%80-sqlite%E8%B3%87%E6%96%99%E5%BA%AB/)

*opendir failed, Permission denied的解决方法:su
(http://blog.csdn.net/yuxin1100/article/details/61622990)

*SQLite 常用函数
(http://www.runoob.com/sqlite/sqlite-functions.html)

####語法

#####SUBSTR(string,m[,n])
將字串由第m個字元開始擷取n個字元。
若m為0時，由第一個字元開始；m為負數時，由字串最後面開始算起。
若省略n，則會傳回m之後的所有字元。
若n為負數，則傳回NULL。

####範例
//1. 要加總當日支出"SELECT * FROM ednMoneyBookKeeper WHERE substr(category_uid,1,1) = 'a' AND substr(date_time,1,7) = '" + chooseDate + "'" + "AND active!='false' order by date_time DESC"

//2. 語法內加總"SELECT * FROM ednMoneyBookKeeper WHERE substr(category_uid,1,1) = 'a' AND substr(date_time,5,2) = '" + chooseMonth + "'" + "AND active!='false' order by date_time DESC"

//3. 語法內加總(b)"SELECT sum(amount) FROM ednMoneyBookKeeper WHERE substr(category_uid,1,1) = 'b' AND substr(date_time,5,2) = '" + chooseMonth + "'" + " AND active!='false' order by date_time DESC"