I know the difference between shared lock and exclusive lock.
But I am not able to figure out a use case when I should go for shared lock instead of exclusive lock. Because using exclusive lock and using normal select query
select * from wmployee where id=4; serves the purpose of reading data when exclusive lock is applied.
So in which case should I be using shared lock? Please could someone explain with a MySQL example statement?