TimeStamp : -
The TIMESTAMP data type is the only way to have MySQL automatically set the time when a row was inserted and/or updated. DATETIME columns can’t do this.
TIMESTAMP columns are identical to DATETIME columns with one important exception — they can be set to take the current time value when a row is created or updated.
Note - If you want to use a timestamp column then set Defalut as shown
create table using timestamp as shown below
CREATE TABLE IF NOT EXISTS `user_tab` (
`x` varchar(200) NOT NULL,
`y` varchar(200) NOT NULL,
`id` varchar(200) NOT NULL,
`usertime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
GUI structure as shown below
Note - if you set defaut as a timestamp then don not use the time stamp column name at the time of insertion it automaticlay insert the time in timestamp column
The TIMESTAMP data type is the only way to have MySQL automatically set the time when a row was inserted and/or updated. DATETIME columns can’t do this.
TIMESTAMP columns are identical to DATETIME columns with one important exception — they can be set to take the current time value when a row is created or updated.
Note - If you want to use a timestamp column then set Defalut as shown
create table using timestamp as shown below
CREATE TABLE IF NOT EXISTS `user_tab` (
`x` varchar(200) NOT NULL,
`y` varchar(200) NOT NULL,
`id` varchar(200) NOT NULL,
`usertime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
GUI structure as shown below
Note - if you set defaut as a timestamp then don not use the time stamp column name at the time of insertion it automaticlay insert the time in timestamp column
