触发器的创建

今天写的一个是我在写项目时要查询各个时间段该单据不同的数据。我就想到了做一个触发器，当他插入或更新时往另一张表插入数据，拼接查询。
好了，上代码。
这是插入的触发器

BEGIN
	INSERT INTO assets_card_perform (
		id,
		main_id,
		depart_id,
		depart_code,
		depart_name,
		assets_type_id,
		assets_type_code,
		assets_type_name,
		assets_ori_value,
		acc_deprec,
		book_value,
		manage_operator,
		manage_operator_name,
		mon_depre_amount,
		spec_type,
		storage_place,
		use_depart_id,
		use_depart_name,
		use_operator,
		use_operator_name,
		use_status,
		operator_date
	)
VALUES
	(
		null,
		new.id,
		new.depart_id,
		new.depart_code,
		new.depart_name,
		new.assets_type_id,
		new.assets_type_code,
		new.assets_type_name,
		new.assets_ori_value,
		new.acc_deprec,
		new.book_value,
		new.manage_operator,
		new.manage_operator_name,
		new.mon_depre_amount,
		new.spec_type,
		new.storage_place,
		new.use_depart_id,
		new.use_depart_name,
		new.use_operator,
		new.use_operator_name,
		new.use_status,
		NOW()
	);


END

这是更新的触发器

CREATE TRIGGER card_perform_update AFTER UPDATE ON assets_card FOR EACH ROW
BEGIN
	INSERT INTO assets_card_perform (
		main_id,
		depart_id,
		depart_code,
		depart_name,
		assets_type_id,
		assets_type_code,
		assets_type_name,
		assets_ori_value,
		acc_deprec,
		book_value,
		manage_operator,
		manage_operator_name,
		mon_depre_amount,
		spec_type,
		storage_place,
		use_depart_id,
		use_depart_name,
		use_operator,
		use_operator_name,
		use_status,
		operator_date
	)
VALUES
	(
		new.id,
		new.depart_id,
		new.depart_code,
		new.depart_name,
		new.assets_type_id,
		new.assets_type_code,
		new.assets_type_name,
		new.assets_ori_value,
		new.acc_deprec,
		new.book_value,
		new.manage_operator,
		new.manage_operator_name,
		new.mon_depre_amount,
		new.spec_type,
		new.storage_place,
		new.use_depart_id,
		new.use_depart_name,
		new.use_operator,
		new.use_operator_name,
		new.use_status,
		NOW()
	);


END

后面还有一个代码查询的拼接，还在研究中，研究完成更新！