mysql - JasonWayne/personal-wiki GitHub Wiki
MySQL 5.7 provides support for server-side prepared statements. This support takes advantage of the efficient client/server binary protocol. Using prepared statements with placeholders for parameter values has the following benefits: - Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. - Protection against SQL injection attacks. The parameter values can contain unescaped SQL quote and delimiter characters.
数据库隔离机制
http://blog.csdn.net/hustyangju/article/details/40116569 看的第一篇
https://my.oschina.net/rotiwen/blog/177786 讲的更清楚明确
http://blog.csdn.net/JIESA/article/details/51317164
http://www.cnblogs.com/zhoujinyi/p/3437475.html with code explain
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html 官方文档
MySQL · 源码分析 · InnoDB Repeatable Read隔离级别之大不同