Re: Tracking a delete
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 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. -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 XrackHosting.com - Mac OS X hosting done right! http://www.xrackhosting.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
RE: Tracking a delete
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]
Re: Tracking a delete
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. Which would be an excellent use for triggers. Sadly, that's not something mysql currently supports. Soon, though, hopefully. Maybe. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Tracking a delete
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 binlog you can look through it. Ok, replication is on so that means I have a bin log, now how do look through it? This is mysql 3.23 on linux. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Tracking a delete
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 binlog you can look through it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
