1Press CTRL+C to copy CREATE TABLE t1 (
2 ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3 dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
4);
1ALTER TABLE whatevertable
2 CHANGE whatevercolumn
3 whatevercolumn TIMESTAMP NOT NULL
4 DEFAULT CURRENT_TIMESTAMP
5 ON UPDATE CURRENT_TIMESTAMP;