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

1 vote168 views3 answers
Union SQL
SQL
0 vote176 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote172 views1 answer
Uncomment listen_address=localhost
SQL
13 votes230 views6 answers
Mysql remove duplicates
SQL
12 votes168 views4 answers
SQL Where
SQL
0 vote162 views1 answer
Complete date is 1 year or not sql server
SQL
1 vote180 views2 answers
How to search date in sql query
SQL
11 votes167 views1 answer
Oracle view ddl
SQL
5 votes182 views4 answers
Upload database mysql command line
SQL
0 vote221 views1 answer
SQL get max per id
SQL