INSERT ... SELECT Syntax

my example

	INSERT INTO t_dms_snapshot_new
		(asset_class_seq, 
		 asset_seq,
		 asset_num,
		 asset_deparment,
		 asset_user )
	SELECT 
		 main.asset_class_seq,
		 main.seq,
		 main.asset_num,
		(SELECT sub.title
		 FROM t_department sub
		 WHERE sub.seq = main.op_department_seq) AS department,
		(SELECT sub.user_name
		 FROM t_user sub
		 WHERE sub.seq = main.op_user_seq) AS asset_user
	FROM 
		t_asset main

INSERT ... ON DUPLICATE KEY UPDATE Syntax

my example

	INSERT INTO t_dms_snapshot_new (asset_num, dms_asset_num, dms_cpu)
	VALUES ('AF1260874302031', 'AF1260874302031', '300')
	ON DUPLICATE KEY UPDATE dms_asset_num='AF1260874302031', dms_cpu='300';

posted(2010-01-26): www.jazzvm.net/board/view.jazz?seq=1326

도움이 되었거나, 의견이 있으시면 커멘트를 남겨주세요. 글을 작성할 때에 참고가 됩니다.
Please leave any comment or opinion regarding this posting. Particularly when you want to refer to this.
That would provide me with good motivation.
thanks --jazzvm

mysql: advanced insert / update jazzvm 2010-01-26 21:47:15

INSERT ... SELECT Syntax

my example

INSERT ... ON DUPLICATE KEY UPDATE Syntax

my example

Board Category

Tags

now reading

recently read

Programming

Recent Commnet

From Picasa Web