/SQL/Adding generated time in row mysql workbench

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

Source: stackoverflow.com

Similar codes

2 votes226 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
2 votes190 views1 answer
Mysql time ago difference
SQL
2 votes195 views1 answer
Sql update alias
SQL
0 vote202 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote202 views1 answer
Mysql DDL
SQL
0 vote196 views1 answer
Show database not empty tables postgres
SQL
0 vote218 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote192 views1 answer
How to print records of employees hired in particular month in oracle
SQL
49 votes226 views6 answers
Install mysql ubuntu
SQL
0 vote193 views1 answer
Formatting code with SQL Developer
SQL