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

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page Commandline SQL question

Notices

Reply
 
Thread Tools Search this Thread
Old 02-26-2013, 09: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, 09:54 PM   #2
theducks
Staff to 4 Cats
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: 10,958
Karma: 2574555
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2,Black Astak PEz, K4NT(now Wifes)
Moderator Notice
Please start a new thread for unrelated questions. I have done this for you this time. Thanks
__________________
Using: Ubuntu(32 bit):Oneric,Precise and XPpro SP3, W7HP(64)- - Libre Office w/Writer2EPUB
theducks is online now   Reply With Quote
 
Enthusiast
Old 02-26-2013, 10: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, 10: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: 22,660
Karma: 3473290
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.
__________________
Get calibre

Notice to all: I can not provide assistance with DRM removal, for legal reasons, so please do not contact me about it.
kovidgoyal is offline   Reply With Quote
Old 02-26-2013, 11:04 PM   #5
theducks
Staff to 4 Cats
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: 10,958
Karma: 2574555
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2,Black Astak PEz, K4NT(now Wifes)
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"
__________________
Using: Ubuntu(32 bit):Oneric,Precise and XPpro SP3, W7HP(64)- - Libre Office w/Writer2EPUB
theducks is online now   Reply With Quote
Reply

« Previous Thread | Next Thread »
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 07:13 PM
MAC Install/Use Commandline tools Riqiv Library Management 11 07-09-2011 03:16 AM
deleting old news via commandline?! gdm11 Calibre 1 06-12-2011 07:33 PM
Commandline only build plord Calibre 11 11-27-2010 06:56 PM
webcomic2lrf, a brutal and simplistic commandline script acidzebra Sony Reader Dev Corner 8 12-23-2008 03:17 PM


All times are GMT -4. The time now is 05:02 PM.

Contact Us - FAQ - Guidelines - Privacy - Archive - Top

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