Kanwal Gill Kanwal Gill -4 years ago 144
MySQL Question

Can't add current time-stamp as default in MySql using phpMyAdmin

enter image description here

Trying to create current date column, when I select default 'none' it works. But if I, select current timestamp then, can't create the column.

Answer Source

You use the unmatched type. Select the type as timestamp not date.

enter image description here

result:

enter image description here

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download