Timeline for Mysql setting a record as deleted or archive
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 25, 2013 at 14:18 | comment | added | Chris Travers | You could probably repurpose Oracle's row-level security to do something like it.... | |
| Feb 25, 2013 at 13:41 | comment | added | Abadis | I think mysql and other db engines must do sth about this! | |
| Feb 25, 2013 at 11:41 | comment | added | Chris Travers | Yes, these are problems. The other solution is just to add "and not deleted" to every where clause. There is no free lunch. | |
| Feb 25, 2013 at 11:00 | comment | added | Abadis | Chris Travers: In View mode we will have 2 problems : first we have to make a view for each table and second is Inserts with duplicate key while you can not insert in to a view! and For Triggers , all your foreign keys will fail and again you have to make duplicate table for each table. | |
| Feb 24, 2013 at 14:50 | history | answered | Chris Travers | CC BY-SA 3.0 |