I have a table called pay_table. there are several fields, like start_date, total_amount, due_day(start_date + 50days), paid_amount, paid_date
Is that possible I can insert start_date, total_amount, and due_day first and leave paid_amount, and paid_date blank? then later on after I get information about paid_amount and paid_date, I will insert these two. How to do that? I only can insert all the fields at the same time. How could I insert the data in the same row on the database at different time?
How about "due_day"? can I directly add 50 days on the start_date? How to do it? If this is incorrect, how could I do it?
Many many thanks