Noted this:
1. have a row, with timestamp field (default current timestamp, on update current timestamp)
2. Dulicate that row. The timestamp value is copyed. I think this should not be done. It should be new current timestamp timestamped upon save of new record.
Timestamp/duplicate row
The discussion:
The only purpose of duplicating row is to spare some time, not have to, manual enter stuff that is the same for original and duplicated record.
Key fields are not copyed by default, doh I think they should be. Forinstance, if I have key from 3 columns, I have to manual enter all of them, not just change wanted one(or two in that case). It is I guess supposed that is inteligent creature duing duplicate record (-: And anyway insert would be aborted due to duplicate key violation.
So. looking at first paragraph, stating that I'm creating new record, timestamped field should be new timestamp.
Example: have a zilion of records, all with same timestamp, then I duplicate one --> create new, save. Damn I just seen something wrong entered. How to find that record --> by timestamp - if it would work as suggested, otherwise it submerge into pile of data.
If it would be normal DATETIMNE, I agree it should be copyed.
The only purpose of duplicating row is to spare some time, not have to, manual enter stuff that is the same for original and duplicated record.
Key fields are not copyed by default, doh I think they should be. Forinstance, if I have key from 3 columns, I have to manual enter all of them, not just change wanted one(or two in that case). It is I guess supposed that is inteligent creature duing duplicate record (-: And anyway insert would be aborted due to duplicate key violation.
So. looking at first paragraph, stating that I'm creating new record, timestamped field should be new timestamp.
Example: have a zilion of records, all with same timestamp, then I duplicate one --> create new, save. Damn I just seen something wrong entered. How to find that record --> by timestamp - if it would work as suggested, otherwise it submerge into pile of data.
If it would be normal DATETIMNE, I agree it should be copyed.
Please login to leave a reply, or register at first.