![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
扬帆丶起航
乘风破浪会有时,直挂云帆济沧海
展开
-
MySQL批量删除表
select CONCAT('drop table ',GROUP_CONCAT(str,'')) from ( select CONCAT(table_name ) as str FROM information_schema.tables where table_name REGEXP 't_phe_event_..' ) s原创 2021-05-31 13:50:05 · 110 阅读 · 0 评论 -
oracle sql 模糊搜索
<if test="ksmc != null and ksmc != ''"> <bind name="ksmc" value="'%' + ksmc + '%'"/> and KSMC like #{ksmc} or KSDM like #{ksmc} or PYM like #{ksmc} or WBM like #{ksmc} </if>原创 2020-11-05 09:56:21 · 147 阅读 · 0 评论