insert into salary_data(select ENTRY_LINE_ID,PAYROLL_NAME,PAYROLL_IDM,TITLE_CUSTOM from salary_data_month )
这是需要操作的sql语句,我想的是在执行导入的时候同时为salary_data中的isEncry字段赋值,而salary_data_month 中并没有这个字段。
求教如何解决!!!!!
最好是写在一个sql语句之中,不需要后续执行update等。
多谢!!!!!
insert into salary_data(ENTRY_LINE_ID,PAYROLL_NAME,PAYROLL_IDM,TITLE_CUSTOM,isEncry) select ENTRY_LINE_ID,PAYROLL_NAME,PAYROLL_IDM,TITLE_CUSTOM,1 from salary_data_month
from前面1就是要赋的值,可以自己变化
insert into salary_data(select ENTRY_LINE_ID,PAYROLL_NAME,PAYROLL_IDM,TITLE_CUSTOM,'这是存放isEncry的初始值' from salary_data_month )
insert into salary_data(
select ENTRY_LINE_ID,PAYROLL_NAME,PAYROLL_IDM,TITLE_CUSTOM,1 AS isEncry
from salary_data_month
)
insert into salary_data
select ENTRY_LINE_ID,PAYROLL_NAME,PAYROLL_IDM,TITLE_CUSTOM,'isEncry' from salary_data_month
insert into salary_data(select ENTRY_LINE_ID,PAYROLL_NAME,PAYROLL_IDM,TITLE_CUSTOM,'isEncry所需要的值' from salary_data_month )