mysql

windows中的mysql库定时备份 -20190214

编制备份处理的批处理文件，并保存为以. bat 形式结尾文件（如 mysqlback.bat）

@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqldump --opt -u root --password=pwd tsp >d:/tsp_%Ymd%.sql
@echo o

参考博客：https://blog.csdn.net/mystonelxj/article/details/79876751

---

mysql模糊匹配大小写 -20190214

SELECT * from tb_test where username REGEXP BINARY '[a-z]+'

---

mysql中的update -20190214

update A inner join(select id,name from B) c on A.id = c.id set A.name = c.name;

---

mysql行转列 -20190214

 select
        max( case p.TECH_CODE when '101' then trans.value end ) '101',
        max( case p.TECH_CODE when '212' then trans.value end ) '212'
        from power_device_technical p
        LEFT JOIN sys_config_translation trans ON trans.id = p.TECH_CONTENT_trans_id
        where p.MODEL_ID = #model_id#
        and trans.value is not null

---

mysql中的查询条件大小写不区分-20190215

	select sn from tb_test where sn = 'TA1707260108' //不区分大小写

	select sn from tb_test where binary sn = 'TA1707260108' //区分大小写

---

mysql explain使用 -20190216

https://blog.csdn.net/zhuxineli/article/details/14455029

http://www.cnitblog.com/aliyiyi08/archive/2008/09/09/48878.html

---

 

mybatis allowMultiQueries解决同时执行多条语句

<property name="url" value="jdbc:mysql://localhost:3306/how2java?characterEncoding=UTF-8&allowMultiQueries=true"/>