OK - the title is sort of tongue-in cheek.

DF 19.0, MySQL, Mertech driver - but I'm not sure any of that matters.

When running Stored Procedures, I'm getting occasional deadlock errors and I have some code to add to the SPs to hopefully deal with them. However, to test the code, I need to create a deadlock situation.

I know MySQL does both read & write locks, but I cannot come up with a way to create the deadlock. I've tried locking a table that's read in the SP & then running the SP - it runs fine. Tried locking it in DF & then writing to it in the SP - runs fine.

Anyone have a way of purposely creating a deadlock? I have a # of users who could, but they never remember what it was they did to create it...