hard20 pts · first answer countstransactionsmysqlupsert
REPLACE INTO removed child rows
In MySQL, a sync job runs REPLACE INTO customers (...) for existing customers. Afterwards their orders, linked with ON DELETE CASCADE, are gone. Why?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- Why InnoDB over MyISAMDatabase Administrator
- Finding slow MySQL queriesDatabase Administrator
- How InnoDB stores table rowsDatabase Administrator
- What an InnoDB secondary index points toDatabase Administrator
- type = ALL in MySQL EXPLAINDatabase Administrator