add created and updatedat fields in mysql

Solutions on MaxInterview for add created and updatedat fields in mysql by the best coders in the world

Search
showing results for - "add created and updatedat fields in mysql"
Ronny
06 Feb 2017
1ALTER TABLE t1
2ADD COLUMN createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
3ADD COLUMN updatedAt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
4
source
similar questions
mysql change timestamp on updatealter table add column forigen key mysqladding current date time in mysql querymysql change database charset and collationmysql update add to existing valuemysql update valuemysql sql add created updated timestamp to existing tablemysql update field from one table to anothermysql alter table add column firstupdate information in a mysql columnmysql add text to existing fieldinsert current date in mysqladd colouns created and updated at in mysqlmysql update column with value from another tablehow to update an attribute in mysqlcreated at and updated at in mysqlmysql add column with default valuehow to assign date field for table in mysql
queries leading to this page
created at mysqlmysql created at and updated at fieldssql server create table add created at columnadd created and updatedat fields in mysqladded sql for adding created at and updated atmysql created at to timestampcreatedat mysqlmysql insert for created atinserting value into created at and updated at in sqladd created at field in the mysqladd updated at field in mysqlmysql insert for updated atupdate table sqlset updatedat to current timestampsql created at automatic creacted timeadd createdat and updateat mysqlmysql set updated atadd createdat to mysqlupdated at created at mysqladding created at and updated at fields in mysqladd created and updatedat fields in mysql