insert

INSERT INTO `auction`.`sys_menu` (`parent_id`, `name`, `title`, `component`, `path`, `perms`, `type`, `icon`, `hidden`, `order_num`, `always_show`, `redirect`, `no_cache`, `affix`, `breadcrumb`, `active_menu`, `time`) 
VALUES 
(355, NULL, '查看自己', NULL, NULL, 'supplier:listMy', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(355, NULL, '查看全部', NULL, NULL, 'supplier:listAll', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(355, NULL, '添加', NULL, NULL, 'supplier:save', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(355, NULL, '修改', NULL, NULL, 'supplier:update', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(355, NULL, '删除', NULL, NULL, 'supplier:delete', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO words ( word, meaning ) SELECT
word,
meaning 
FROM
	all_words a left OUTER join 
 (
	SELECT
		a.id 
	FROM
		all_words a
		JOIN good_words g ON a.word = g.Word 
		OR a.word = g.FS 
		OR a.word = g.GQFC 
		OR a.word = g.GQS 
		OR a.word = g.XZFC 
	) ids on a.id = ids.id
	where ids.id is null;

INSERT  into T_MAP_ICON (FD_DEVICE_ID , FD_ASSOCIATE_ID,FD_TYPE,FD_LEVEL)
 SELECT FD_ROWID AS FD_DEVICE_ID,'149'AS FD_ASSOCIATE_ID,'device'AS fd_TYPE ,'device' AS FD_LEVEL 
	FROM T_BASEINFO 
	WHERE FD_FACTORYCODE = '149';

MERGE INTO T_MAP_ICON i
	USING (SELECT * FROM T_BASEINFO WHERE FD_BRANCHCODE ='163')  b
		ON i.FD_DEVICE_ID = b.FD_ROWID
WHEN MATCHED THEN
	UPDATE SET i.FD_ASSOCIATE_ID = '163'
WHEN NOT MATCHED THEN
	INSERT  (FD_DEVICE_ID , FD_ASSOCIATE_ID,FD_TYPE,FD_LEVEL)
		VALUES (b.FD_ROWID ,'163','device','device');