呵呵sql

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 )

posted @ 2016-09-05 16:26  宝贝企鹅  阅读(103)  评论(0编辑  收藏  举报