Files
ShoppingList/updateSQL.sql

4 lines
156 B
MySQL
Raw Permalink Normal View History

2017-02-07 20:09:46 +00:00
2013-11-07 - delete orphaned entries:
update entry set status='d' where entry.status != 'd' and shopkey not in (select key from shop where status != 'd');