laravel colum timestamp auto update code example

Example 1: adding generated time in row mysql workbench

ALTER TABLE
 MODIFY dt_created datetime DEFAULT CURRENT_TIMESTAMP

ALTER TABLE
 MODIFY dt_modified datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Example 2: mysql update auto

ALTER TABLE tbl AUTO_INCREMENT = 100;

Tags:

Sql Example

Related