MYSQL:Unknown column '字段名' in 'field list' 错误

dynamic 读值少写#号

错误写法

INSERT INTO pay_product_sep(
        <dynamic prepend=" ">
            <isNotEmpty prepend="," property="productCode">product_code</isNotEmpty>
            <isNotEmpty prepend="," property="sepStatus">sep_status</isNotEmpty>
        </dynamic>
            )VALUES(
        <dynamic prepend=" ">
            <isNotEmpty prepend="," property="productCode">product</isNotEmpty>
            <isNotEmpty prepend="," property="sepStatus">sepStatus</isNotEmpty>
            )
        </dynamic>

低级错误 正确写法

INSERT INTO pay_product_sep(
		<dynamic prepend=" ">
			<isNotEmpty prepend="," property="productCode">product_code</isNotEmpty>
			<isNotEmpty prepend="," property="sepStatus">sep_status</isNotEmpty>
		</dynamic>
			)VALUES(
		<dynamic prepend=" ">
			<isNotEmpty prepend="," property="productCode">#product#</isNotEmpty>
			<isNotEmpty prepend="," property="sepStatus">#sepStatus#</isNotEmpty>
			)
		</dynamic>