select sr.id
,sr.rule_num as ruleNum
,sr.rule_name as ruleName
,sr.separator as 'separator'
,m.menu_id as menuId
,m.menu_name as menuName
,sr.status as status
,sr.remark as remark
,sr.create_by as createUserId
,sr.update_by as updateUserId
,u.user_name as createUserName
,u.nick_name as createNickName
,s.user_name as updateUserName
,s.nick_name as updateNickName
,date_format(sr.create_time, '%Y-%m-%d %H:%i:%s') as createTime
,date_format(sr.update_time, '%Y-%m-%d %H:%i:%s') as updateTime
from serial_rule sr
left join sys_user u on sr.create_by=u.user_id
left join sys_user s on sr.update_by=s.user_id
left join sys_menu m on sr.menu_id
mybatis plus中字段名与关键字相同
于 2022-04-02 15:41:01 首次发布