Commandline SQL question

cmkread · 02-26-2013, 09:50 PM

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

theducks · 02-26-2013, 09:54 PM

Moderator Notice
Please start a new thread for unrelated questions. I have done this for you this time. Thanks

cmkread · 02-26-2013, 10:32 PM

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....

kovidgoyal · 02-26-2013, 10:56 PM

You need to first get the list of ids you want to remove and then remove them with a single call to calibredb remove.

theducks · 02-26-2013, 11:04 PM

Quote:

Originally Posted by cmkread

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"

02-26-2013, 09:50 PM	#1
cmkread Junior Member 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

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

02-26-2013, 09:54 PM	#2
theducks Well trained by Cats Posts: 29,799 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Moderator Notice Please start a new thread for unrelated questions. I have done this for you this time. Thanks

02-26-2013, 10:32 PM	#3
cmkread Junior Member 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....

02-26-2013, 10:56 PM	#4
kovidgoyal creator of calibre Posts: 43,852 Karma: 22666666 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.