concurrency VS consistency
How to solve this problem? –lock
DML
DDL
transaction isolation level
dirty read : data which is not commit
unrepeatable read : data which is not the same at the second time
phantom read : data which is much more than last time;
transaction
commit
rollback
This part is very complex.
Need study more detail