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.com 407.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]