I need help with implementing MySQL transactions with PHP. Specifically, I'm confused between the flags WITH CONSISTENT SNAPSHOT
, READ WRITE
, and READ ONLY
, what their differences are, and how they relate to table locking. I already read the MySQL reference manual but I'm still confused.