首页 > 代码库 > lll
lll
SELECT reg.id,reg.name,flo.id,flo.name FROM gt_resource.res_region AS reg LEFT JOIN gt_resource.res_floor AS flo ON reg.parent_id = flo.id WHERE flo.id = 2; UPDATE gt_lighting.res_lights SET purpose = 5; UPDATE gt_lighting.res_lights SET purpose = 1 WHERE id IN (111,113,108,107,93,96,100,90,89,88,91,92,75,76,77,78,79,80,81,82,74,73,130,127,128,117,134,162,148,151,155,141,142,147,154,153,144,158,156,157,120,163,170,172,178,169,137,136,182,119,122,123,207,206,198,201,202,51,47,43,21,29,30,39,44,45,52,53,54,55,56,46,48,49,50,23); UPDATE gt_lighting.res_lights SET purpose = 2 WHERE id IN (43,61,34,6,7,8,9,10,11,12,13,15,16,17,18,199,203,204,114,101,94,102,72,67,64,116,118,149,150,143,152,146,145,121,187,177,171,168,174,180,181,184); UPDATE gt_lighting.res_lights SET purpose = 3 WHERE id IN (106,112,109,97,98,99,95,70,66,65,71,63,132,131,133,126,138,176,173,179,205,25,26,31,33,60,19,28); UPDATE gt_lighting.res_lights SET purpose = 4 WHERE id IN (41,57,24,27,37,59,14,200,140,167); SELECT lig.id,lig.name,lig.fid,flo.name,lig.rid,reg.name,lig.purpose,lig.icon FROM gt_lighting.res_lights AS lig LEFT JOIN gt_resource.res_floor AS flo ON lig.fid = flo.id LEFT JOIN gt_resource.res_region AS reg ON lig.rid = reg.id ORDER BY lig.id; UPDATE gt_lighting.res_lights SET icon = ‘e620‘ WHERE `name` LIKE ‘%花灯‘ OR `name` LIKE ‘%柜灯‘; UPDATE gt_lighting.res_lights SET icon = ‘e624‘ WHERE `name` LIKE ‘%筒灯‘; UPDATE gt_lighting.res_lights SET icon = ‘e64b‘ WHERE `name` LIKE ‘%射灯‘; UPDATE gt_lighting.res_lights SET icon = ‘e64c‘ WHERE `name` LIKE ‘%灯带‘ OR `name` LIKE ‘%壁灯‘; UPDATE gt_lighting.res_lights SET icon = ‘e621‘ WHERE `name` LIKE ‘%窗帘‘; UPDATE gt_lighting.res_lights SET icon = ‘e643‘ WHERE `name` LIKE ‘%夜灯‘; UPDATE gt_lighting.res_lights SET icon = ‘e696‘ WHERE `name` LIKE ‘%LOGO%‘;
lll
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。