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
Last activity: Feb 24, 2013, 09:26 PM