On 2016-03-10 05:12, AndyHC wrote:
Use autoinc but wrap your child-parent-grandparent inserts in a transaction - or better still an SP.
I don't like the idea of committing until I'm totally sure I want to add those records; hence the disconnected-until-ready-to-save approach.