MySQL上讀寫鎖的方式記錄

共享鎖：select * from tableName where id = 100 lock in share more

排它鎖：select * from tableName where id = 100 for update