select count(1) from biz_project_management select * from biz_project_management ${ew.customSqlSegment} select PROJECT_TYPE_ AS type,SUM(PROJECT_MONEY_) AS total from biz_project_management ${ew.customSqlSegment} GROUP BY PROJECT_TYPE_ update biz_project_management set CURRENT_PROJECT_ = 0 where IS_DELE_='0' update biz_project_management set CURRENT_PROJECT_ = 1 where ID_ = ( select fake.id_ from ( select ID_ from biz_project_management where IS_DELE_ = '0' limit 1 )fake) select ID_ from biz_project_management where PROJECT_MANAGER_ID_ LIKE CONCAT('%',#{userId},'%')