• Welcome to The Network People Support Forums. Please login or sign up.
December 04, 2021, 08:55:57 PM

deleted=1

Started by shaun, June 22, 2005, 04:33:27 PM

Previous topic - Next topic

shaun

Is option some where i'm not seeing that will tell nictool to stop setting deleted=1 and to just remove the row from the db?

a quick count on just my records table today showed over 8 Million rows with deleted=1  Shocked

LogicX

be SURE you did you query correct:

select * from nt_zone_record where deleted='1';
NOT
select * from nt_zone_record where deleted=1;


how I clear it:
okay:
delete from nt_zone_record where deleted='1';
NOT OKAY:
delete from nt_zone_record where deleted=1;

I've deleted my nictool DB atleast twice now by making that mistake. (thankfully I run select * first)
--- May this post be indexed by spiders, and archived for all to see as my internet epitaph.
http://FPuX.com" target="_blank">http://FPuX.com

shaun

thanks for the replay/info, luckily i always wrap my query statments input with ''.  But i can see why you posted that with my above post  Very Happy

Oh well, guess i'll write up a cron job or somthing that goes through a cleans the db.