Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 02-26-2013, 10:50 PM   #1
cmkread
Junior Member
cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.
 
cmkread's Avatar
 
Posts: 8
Karma: 471294
Join Date: Feb 2013
Device: nook touch
Commandline SQL question

Thank YOU for this great program Kovid. I have 5000 entries by error, loaded my C: drive and very slow trying to delete using calibredb remove ....
Is there a sql command I can use. I believe I have an old SQL MS version, have not done any SQL for awhile, but was very db savy at one time... What do you recommend.
Delete the db and reinstall easier, k,, or sql db erase
cmkread is offline   Reply With Quote
Old 02-26-2013, 10:54 PM   #2
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,259
Karma: 6020309
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Moderator Notice
Please start a new thread for unrelated questions. I have done this for you this time. Thanks
theducks is offline   Reply With Quote
Old 02-26-2013, 11:32 PM   #3
cmkread
Junior Member
cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.cmkread ought to be getting tired of karma fortunes by now.
 
cmkread's Avatar
 
Posts: 8
Karma: 471294
Join Date: Feb 2013
Device: nook touch
I feel so ignorant about these things.. ugh. Thank you. sorry for work. I looked for new thread, but, didn't find anything where I would think it would be normally on menu or options....
cmkread is offline   Reply With Quote
Old 02-26-2013, 11:56 PM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,436
Karma: 5383257
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You need to first get the list of ids you want to remove and then remove them with a single call to calibredb remove.
kovidgoyal is offline   Reply With Quote
Old 02-27-2013, 12:04 AM   #5
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,259
Karma: 6020309
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by cmkread View Post
I feel so ignorant about these things.. ugh. Thank you. sorry for work. I looked for new thread, but, didn't find anything where I would think it would be normally on menu or options....
Button: at the top of the forums list: LEFT side "New Thread"
theducks is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cover creator commandline ilovejedd Calibre 2 08-16-2011 08:13 PM
MAC Install/Use Commandline tools Riqiv Library Management 11 07-09-2011 04:16 AM
deleting old news via commandline?! gdm11 Calibre 1 06-12-2011 08:33 PM
Commandline only build plord Calibre 11 11-27-2010 07:56 PM
webcomic2lrf, a brutal and simplistic commandline script acidzebra Sony Reader Dev Corner 8 12-23-2008 04:17 PM


All times are GMT -4. The time now is 07:51 AM.


MobileRead.com is a privately owned, operated and funded community.