呵呵sql
来源：互联网 发布：淘宝店铺怎么才能靠前 编辑：程序博客网 时间：2024/06/06 03:39
INSERT INTO fnd_document_folder_structure_t
(folder_name,parent_folder_id,company_type_id,inv_flag,con_flag,sup_flag,archives_flag,leaf_flag,creation_date,created_by,last_updated_date,last_updated_by)
SELECT
'其他',(SELECT folder_id FROM fnd_document_folder_structure_t WHERE folder_name = '旁站监理记录'),'3','N','Y','Y','N','Y',NOW(),'0',NOW(),'0'
FROM DUAL
DELETE FROM fnd_user_t WHERE user_name IN(
SELECT a.user_name FROM (SELECT fnd_user_t.* FROM fnd_user_t WHERE user_name LIKE '%测试%' OR user_name LIKE '%演示%' OR user_name = '') a )
(folder_name,parent_folder_id,company_type_id,inv_flag,con_flag,sup_flag,archives_flag,leaf_flag,creation_date,created_by,last_updated_date,last_updated_by)
SELECT
'其他',(SELECT folder_id FROM fnd_document_folder_structure_t WHERE folder_name = '旁站监理记录'),'3','N','Y','Y','N','Y',NOW(),'0',NOW(),'0'
FROM DUAL
DELETE FROM fnd_user_t WHERE user_name IN(
SELECT a.user_name FROM (SELECT fnd_user_t.* FROM fnd_user_t WHERE user_name LIKE '%测试%' OR user_name LIKE '%演示%' OR user_name = '') a )
0 0
