Sample Header Ad - 728x90

Mysql setting a record as deleted or archive

1 vote
1 answer
589 views
Is there any way to omit some records in mysql select statement and not deleting them? We can easily add a column for example deleted and set it to 1 for deleted ones and keep them but the problem is that we have to put where deleted = 1 in all queries. What is the best way to keep some records as an archive?
Asked by Abadis (111 rep)
Feb 24, 2013, 01:30 PM
Last activity: Feb 24, 2013, 09:26 PM