MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SET SESSION sql_mode = 'ALLOW_INVALID_DATES';
CREATE TABLE tab(
`DateAdded` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`DateUpdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
ALTER TABLE tab
MODIFY `DateAdded` timestamp DEFAULT CURRENT_TIMESTAMP;
INSERT INTO tab(DateUpdated) VALUES (CURRENT_TIMESTAMP)
SELECT *
FROM tab


DateAdded
DateUpdated


2018-06-25 06:22:04
2018-06-25 06:22:04