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: 206
Karma: 573170
Join Date: Oct 2011
Device: Sony T2
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