摘要: SELECT * FROM sys_menu where parent_id='2' and (id=13 or id=2) SELECT * from sys_role_menu where role_id=1 and menu_id not in( 13,2,14,17,20,30,4,3,56 阅读全文
posted @ 2020-03-20 22:40 hoge 阅读(194) 评论(0) 推荐(0) 编辑
摘要: mysql uuid SELECT LB_MATLISTS_20200120.* from LB_MATLISTS_20200120 GROUP BY matCode // 这样写会重复 select replace(uuid(),"-","") as uuid; insert into scm_m 阅读全文
posted @ 2020-03-20 10:30 hoge 阅读(254) 评论(0) 推荐(0) 编辑