数据库----sql及ddl-dcl-dml

参考博客：
1、sql及DDL语句操作
http://blog.csdn.net/miachen520/article/details/51736333

2、DDL DML DCL语句
http://blog.chinaunix.net/uid-26805356-id-3211205.html

3、Sql语句中的DDL、DML、DCL的介绍
http://blog.knowsky.com/221957.htm

4、DQL、DML、DDL、DCL的概念与区别
http://blog.csdn.net/tomatofly/article/details/5949070

5、SQL事务+隔离级别+阻塞+死锁
https://www.cnblogs.com/XACOOL/p/5642298.html
https://www.cnblogs.com/tian666/p/7852646.html

6、锁表与解锁
--查看Mysql锁表语句
http://blog.51cto.com/215687833/1923549
--oracle/mysql查看锁表与解锁表
https://blog.csdn.net/itao1067/article/details/76851231

----常用SQL
1、mybatis中针对不同数据库的模糊查询

<if test="name != null and name != ''">
				AND a.name LIKE
				<if test="dbName == 'oracle'">'%'||#{name}||'%'</if>
				<if test="dbName == 'mssql'">'%'+#{name}+'%'</if>
				<if test="dbName == 'mysql'">concat('%',#{name},'%')</if>
			</if>