Thread: Export list of books from KoboReader.sqlite
View Single Post
Old 07-01-2022, 10:19 PM   #15
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by mortimer7 View Post
i believe in you but i can't find "ReadStatus" column.
For example, in this book where is it?
Really? If you can't see it, then I suggest copying the word and doing a search in this thread to find it. You have pasted it as part of the list of columns.

And for that book, the value is "1" and you are 5% through it.

And, as to @Quoth's comments, I can see a simplicity in pasting the INSERT statement. DB Browser does make it easy to copy in that format. But, I would not trust those insert statements. They do not have the list of columns, so the order of the values must match the order in the database and there must be a value for each column. Using INSERT statements like that is dangerous and should get rejected in any code review. And as the others have said, if you are intending to follow this at all, you need to go and do a SQL course of some sort.
davidfor is offline   Reply With Quote