- 博客(3)
- 收藏
- 关注
原创 mysql CASE WHEN
SELECT case when built_area < 100 then 1when (300>=built_area and built_area>=100) then 2when (500>=built_area and built_area>=301) then 3when (700>=built_area and built_area>=501) then 4when (900>=built_area and built_area>
2021-12-24 17:31:06 243
原创 mysql FIND_IN_SET(‘‘,‘‘)
SELECT 字段 FROM table where FIND_IN_SET('条件',REPLACE(字段,'字段分隔符','要替换的符号'))FIND_IN_SET查询的字段只能为逗号 , 分隔,如果非逗号 , 分隔需要使用REPLACE函数替换
2021-11-26 15:39:41 750
原创 layui获取iframe
layui获取iframe父页面子页面(iframe)父页面 $(document).on('click','.mapShow',function(){ var data = table.cache["demo"]; //layui table 表格的全部值 var location = $("#location").val(); layer.open({ type: 2,
2021-11-19 11:45:35 1599
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人