I have problem with mysql timestamp

[Abdul Fattah]

Hai, I'am Abdul Fattah, I have problem..

I have MySQL Server 4.0.20. running on Mandrake Linux, i'm using MyISAM table type with around 70
tables.

For date-time field i use timestamp type, but i found some problem about that.

if i use sql for insert or update my table with timestamp field, i confuse beacuse that field is auto insert with current date.

can i 'alter filed' for all table with one filed in first index to handle that problem.
please help me..

thanks for all