View Single Post
Old 07-27-2012, 07:38 PM   #12
pssquirrel
ebooknut
pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.pssquirrel ought to be getting tired of karma fortunes by now.
 
pssquirrel's Avatar
 
Posts: 290
Karma: 688154
Join Date: Oct 2011
Device: Kindle Voyage
I am loving this command line function (thanks again Grimborg and Jarsto!)

Here's another tweak: "update books set reading_time=added_date where reading_time is null;"

This way each book has a unique reading_time, the date is more meaningful than January 1, 1970, and it still takes only one command.
pssquirrel is offline   Reply With Quote