首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 移动开发 > 移动开发 >

复制一起记录 insert into select

2012-09-28 
复制一行记录 insert into selectinsert into tb_sys_menu(menu_id,menu_nm,menu_desc,menu_pid,menu_leve

复制一行记录 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'

热点排行