inserting 2 fields from 1 table to another table

[hridya]

hai all


I am using a query to insert 2 fields from my temp table( emp_attendance_temp ) to the attendance table.
insert is happening but the problem is emp_attendance tables id is set as the id of the temp tables id.

I don't want to set the ID from the temp table.
i want the Id in emp_attendance in its incremental sequence


INSERT INTO emp_attendance (employee_id,attendance_status_code) select employee_id,attendance_status_code from emp_attendance_temp

[hridya]

hai all


I am using a query to insert 2 fields from my temp table( emp_attendance_temp ) to the attendance table.
insert is happening but the problem is emp_attendance tables id is set as the id of the temp tables id.

I don't want to set the ID from the temp table.
i want the Id in emp_attendance in its incremental sequence


INSERT INTO emp_attendance (employee_id,attendance_status_code) select employee_id,attendance_status_code from emp_attendance_temp

Heading:inserting 2 fields from 1 table to another table

[ronverdonk]

Can't really guess what your problem is here. But if you don't want to insert the attendance_id into the attendance table, then isn't this the statement you look for

INSERT INTO emp_attendance (0,attendance_status_code) select attendance_status_code from emp_attendance_temp
 

Ronald

[hridya]

oh i am sorry

the problem is with sqlyog.when i closed and restarted it works correctly


your answer given is correct(the problem was my Id was not setting correct)

thanks

[ronverdonk]

oh i am sorry

the problem is with sqlyog.when i closed and restarted it works correctly


your answer given is correct(the problem was my Id was not setting correct)

thanks

Glad it works correct now. See you again next time.

Ronald