UPDATE resource_sub1 SET last_invoice_id_c=0 WHERE last_invoice_id_c IS NULL ; UPDATE resource_sub1 SET last_teacher_id_c=90000 WHERE last_teacher_id_c IS NULL ; UPDATE resource_sub1 SET last_student_id_c=0 WHERE last_student_id_c IS NULL ;