> >How can I see if a record was deleted from a database?
> You can attempt to SELECT it, and if you get no result, it's not there.
> But that doesn't necesarily mean that it was once there and has now been
> deleted. If you want to determine that, you'll need to create a log
> of record deletions
Thank You.***
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 1:59 PM
> To: Jeff McKeon; [EMAIL PROTECTED]
> Subject: Re: Tracking a delete
>
>
> At 12:54 -0400 8/8/03, Jeff McKeon wrote:
> >How can I
At 12:54 -0400 8/8/03, Jeff McKeon wrote:
How can I see if a record was deleted from a database?
Jeff
You can attempt to SELECT it, and if you get no result, it's not there.
But that doesn't necesarily mean that it was once there and has now been
deleted. If you want to determine that, you'll nee
Or do not delete them at all, simply flag them as deleted then proceed
otherwise. Develop some routine to purge/backup the "deleted" records after
a given period of time.
on 8/8/03 2:08 PM, Chris Boget at [EMAIL PROTECTED] wrote:
>>> How can I see if a record was deleted from a database?
>> You
>
>
> > Ok, I know it WAS there because we have two similar tables
> that should
> > contain sister records. One table has a record the other
> doesn't so
> > it had to have been deleted. I need to find out WHEN it
> was deleted.
> >
> > How do I create a log of record deletes?
> >
>
>
> Ok, I know it WAS there because we have two similar tables that should
> contain sister records. One table has a record the other doesn't so it
> had to have been deleted. I need to find out WHEN it was deleted.
>
> How do I create a log of record deletes?
>
If you keep the update log or the
How can I see if a record was deleted from a database?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
