
Question: To simulate a lock in mysql I can grab the row with the following: BEGIN; SELECT * FROM table WHERE id=1 FOR UPDATE; Now, if I try and update that row (from another connection) it will raise the following error after innodb_lock_wait_timeo...
Real Questions. Clean Answers. All About Databases.
A database Q&A blog for those who’d rather debug queries than read documentation. Practical answers to real questions — mostly SQL Server and MySQL, with a pinch of sarcasm and a love for clean code.
Markdown supported · ⌘↵ to post
No responses yet.