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? Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. 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 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 need to create a log of record deletions. > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
