MySQL上读写锁的方式记录

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

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