1.驾驶证 2.家里东西维修(已完成) 3.就是交过的钱当学费了 4.好好上班 select * from tb_dictionary where title ='系统方案' select * from tb_dictionary where title like '%防爆固定照明' select * from tb_dictionary where title like '%防爆移动照明' select * from tb_dictionary where title like '%防爆灯具%' and appId='eb50e297-b660-40bf-9f8e-23f289' -- select ('防爆移动照明','3305','0','','防爆灯具','','eb50e297-b660-40bf-9f8e-23f289' ) union --update tb_dictionary set contents=REPLACE(contents,'657','2657') where parentId=3419 and appId='eb50e297-b660-40bf-9f8e-23f289' select *from tb_dictionary where id=3305 select *from tb_dictionary where parentId=3314 insert into tb_dictionary (title,parentId,sort,contents,parentTitle,configKey,appId) select '分类下(210px*265px)','3627','0','s_index_2659_class','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select 'banner(1920px*465px)','3627','0','s_index_2659_banner','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select 'Banner右(210px*155px)','3627','0','s_index_2659_banner_right','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select '品牌(240px*305px)','3627','0','s_index_2659_brand','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select '品牌下(1190px*100px)','3627','0','s_index_2659_brand_b','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select '楼层(210px*490px)','3627','0','s_index_2659_floor','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select '楼层上(1190px*100px)','3627','0','s_index_2659_fl_u','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select '楼层下(1190px*100px)','3627','0','s_index_2659_fl_b','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' union all select '防爆压力表楼层左','3627','0','s_product_index_2659_floor','防爆压力表','','eb50e297-b660-40bf-9f8e-23f289' --insert into tb_dictionary (title,parentId,sort,contents,parentTitle,configKey,appId) --select '防爆温度表','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '防爆压力表','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '变送器','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '液位仪探棒','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '安全栅','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '流量开关','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '视镜','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '传感器','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '液位仪表','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '电动执行器','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '电磁流量计','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' union --select '工具类仪表','3305','0','','商品聚合页','','eb50e297-b660-40bf-9f8e-23f289' select *from tb_dictionary where id=3305 3314 select *from tb_dictionary where parentId=3591 3552 select * from tb_dictionary where title like '%变送器%'