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 vote158 views1 answer
Python sqlalchemy connection show server
SQL
0 vote128 views1 answer
Postgresql create user roles
SQL
0 vote136 views1 answer
How to get inserted id in sql server
SQL
5 votes148 views1 answer
Mysql count newlines in field
SQL
0 vote98 views1 answer
Mysql workbench search all tables
SQL
0 vote190 views1 answer
Oracle temporary table
SQL
1 vote137 views1 answer
Psql connections
SQL
9 votes145 views3 answers
Mysql run sql file
SQL
0 vote167 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote185 views1 answer
Size of all tables in a schema oracle
SQL