개발

select * from dates
where dte = date('now');

select dtm from datetimes
where dtm >= datetime(date('now'))
and dtm < datetime(date('now', '+1 day'));

select datetime(dtm, 'unixepoch', 'localtime') from unix
where dtm >= strftime('%s', date('now'))
and dtm < strftime('%s', date('now', '+1 day'));

http://hangaebal.blogspot.kr/2014/06/web-sql-search-on-dates.html
https://gist.github.com/dwurf/8929425

- SQLite Syntax Documentation

- SQLite Documentation

http://sqlite.org/lang.html

db.transaction(tx) {
    doQuery(tx, "SELECT * FROM TABLE",[],theSuccessHandler)
});

function doQuery(tx, query, values, successHandler) {
    tx.executeSql(query, values, successHandler, errorHandler);
    function errorHandler(transaction, error) {
        alert("Error : " + error.message + " in " + query);
    }
}

http://hangaebal.blogspot.kr/2014/06/web-sql-error-handling.html

http://stackoverflow.com/questions/16559832/how-to-get-the-context-of-a-web-sql-error

> 초기값 셋팅에 활용

"INSERT OR UPDATE"
> 중복시 값 변경에 활용

- INSERT OR IGNORE

- INSERT OR UPDATE

http://hangaebal.blogspot.kr/2014/06/web-sql-insert-or.html