读书人

复制一起记录 insert into select

发布时间: 2012-09-28 00:03:35 作者: rapoo

复制一行记录 insert into select

insert into tb_sys_menu  (menu_id,   menu_nm,   menu_desc,   menu_pid,   menu_level,   link_url,   sys_cd,   menu_stat_cd,   disp_seq,   etr_id,   etr_date,   mdf_id,   mdf_date,   is_data_menu,   open_yn,   menu_id_old,   menu_pid_old)  select '302014',      '采购未到货',         t2.menu_desc,         t2.menu_pid,         t2.menu_level,         'purch/po_not_receive.ugo',         t2.sys_cd,         t2.menu_stat_cd,         t2.disp_seq,         t2.etr_id,         t2.etr_date,         t2.mdf_id,         t2.mdf_date,         t2.is_data_menu,         t2.open_yn,         t2.menu_id_old,         t2.menu_pid_old    from tb_sys_menu t2   where t2.link_url = 'purch/podtl_query_trace.ugo'

读书人网 >移动开发

热点推荐