Select Insert Example

INSERT INTO llx_user_rights (rowid, entity, fk_user, fk_id)

select rowid+30000 as rowid, entity, 16 as fk_user, fk_id from llx_user_rights

where fk_user = 13

and fk_id not in (select fk_id from llx_user_rights where fk_user = 16)

UPDATE mp_timesheet AS U1, mp_timesheet AS U2 

SET U1.timesheet_date = DATE(U2.timesheet_in)

WHERE U1.timesheet_id = U2.timesheet_id