Wow, worked (to an extent). The column Begin_Date is updated correctly, but the Timestamp column has attribute "on update CURRENT_TIMESTAMP", and TYPE "TIMESTAMP", so it changes the entire column to 2012-05-29 17:15:48, which is the time I executed the command.
How to get around that?
Ideally need each row from Column "begin_date" and "timestamp" to be the same, like this
Primary_id--- Begin_Date -------------Timestamp
1.------------2008-09-02--------------2008-09-02 21:48:09
2.------------2008-09-03--------------2008-09-03 15:19:01
3.------------2008-09-14--------------2008-09-14 01:23:12
4.------------2008-09-27--------------2008-09-27 19:03:59
but at the moment, what I am getting is this:
Primary_id--- Begin_Date -------------Timestamp
1.------------2008-09-02--------------2012-05-29 17:15:48
2.------------2008-09-03--------------2012-05-29 17:15:48
3.------------2008-09-14--------------2012-05-29 17:15:48
4.------------2008-09-27--------------2012-05-29 17:15:48
Do I make sense? Really appreciating your help.