I’m using MySQL and myphpadmin on my webhost.
I have a column logon_time in the table allstudents19BE, set as TIMESTAMP
I was hoping it would show me the logon time, especially after any update.
When I look at the table structure in myphpadmin, the column logon_time has:
type: timestamp
default: CURRENT_TIMESTAMP
extra: ON UPDATE CURRENT_TIMESTAMP
I am making new tables for a new school term, so I thought, maybe creation doesn’t count as update.
I imported the csv file again with some different data in it.
The timestamp in the column logon_time stays the same.
What am I doing wrong? Why am I not getting the CURRENT_TIMESTAMP??