On Thu, Mar 23, 2006 at 04:17:44PM +0000, Alec.Cawley@stripped wrote:
> Lots of ways round this. Instead of deleting records, add a boolean
> "deleted" flag. All selects then need to add "and deleted = 0". But you can
> find a (random) deleted row with "select id from table where deleted = 1
> limit 1". If this returns a result, use update to re-populate that record,
> clearing the deleted flag. If it returns nothing, use insert to create a
> new record.
Attachment: [application/pgp-signature] Digital signature signature.asc