[thelist] mySql question...

[jsWalter]

Is it possible to have the database automatically update a field with data
from another filed if that first field is not defined?

If I have 2 fields, f1 and f2

I do an INSERT on f1, but don't give f2 anything, I want the db to
auto-magically copy the data from f1 and insert it into f2.

Any ideas?

Thanks

Walter