![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
晒太阳的布偶
这个作者很懒,什么都没留下…
展开
-
MySql---INSERT的各种用法
插入语句1、最简单的INSERT INTO tableName (colNmae1, colName2) VALUES (value1, value2);2、循环插入INSERT INTO tableName ( colNmae1, colName2 ) VALUES <foreach collection="list" item="item" open="" close="" separator=","> ( #{i原创 2021-02-02 14:29:10 · 116 阅读 · 0 评论 -
MySql---CASE WHEN的各种用法
话不多说,直接贴sql。SELECT DATA_VALUE dataValue, NUMBER number, PARAM param, CASE <foreach collection="mapList" item="item" open="" close="" separator=","> WHEN NUMBER = #{item.number} AND PARAM = LEFT(#{item.param}, 4) THEN #{item.ratedVolt} </f原创 2020-10-10 15:46:35 · 287 阅读 · 1 评论