Created at and updated at in mysql

ADD COLOUNS CREATED AND UPDATED AT IN MYSQL

ALTER TABLE t1
ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

Source: stackoverflow.com

Created at and updated at in mysql

ALTER TABLE t1
ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

Source: stackoverflow.com

Similar codes

0 vote293 views1 answer
Mysql update set sum
SQL
0 vote369 views1 answer
Oracle simple quote
SQL
4 votes271 views2 answers
Oracle set date format
SQL
1 vote279 views3 answers
Default password of mysql
SQL
15 votes288 views2 answers
Open postgress in terminal mac
SQL
0 vote253 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote308 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote417 views5 answers
Right join
SQL
0 vote280 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote299 views1 answer
Where field is null sql knex
SQL