CURRENT_TIMESTAMP shows all zeroes

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

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??

How are you importing the CSV?

Importing with phpMyAdmin, or my own little importCSV.php

Sponsor our Newsletter | Privacy Policy | Terms of Service