insert
SELECT (SELECT CONCAT( 'BD' , DATE_FORMAT(NOW(), '%Y%m') , LPAD( CAST(( CAST( SUBSTR( IFNULL( MAX(BD_CD) ,CONCAT( 'BD' ,DATE_FORMAT(NOW() , '%Y%m') ,'00000' ) ),9,5) AS SIGNED ) + 1 ) AS CHAR) ,5 ,'0' )) FROM ${dbId}.T_BD WHERE TENANT_CD = #{tenantCd} AND SUBSTRING(BD_CD,1,8) = CONCAT('BD',DATE_FORMAT(NOW(), '%Y%m'))) AS BD_CD , (SELECT IFNULL( MIN(0), 0 ) IFNULL( MAX(BD_NO)+1, 1) FROM ${dbId}.T..