mysql 默认值不起作用_mysql默认值不起作用

insert into stock_goods_manage

dept_id,

semester_id,

in_total_num,

out_total_num,

plan_in_num,

plan_out_num,

temporary_in_num,

temporary_out_num,

check_total_num,

total_num,

start_semester_num,

end_semester_num,

goods_id,

goods_code,

goods_name,

goods_abb,

model,

unit,

kind,

price,

remark

#{deptId},

#{semesterId},

#{inTotalNum},

#{outTotalNum},

#{planInNum},

#{planOutNum},

#{temporaryInNum},

#{temporaryOutNum},

#{checkTotalNum},

#{totalNum},

#{startSemesterNum},

#{endSemesterNum},

#{goodsId},

#{goodsCode},

#{goodsName},

#{goodsAbb},

#{model},

#{unit},

#{kind},

#{price},

#{remark}