Question : I want to make a trigger to record the time of any update as: CREATE TRIGGER col_update AFTER […]
Tag: row-modification-time
Create a trigger on all the last_modified columns in PostgreSQL
Question : In PostgreSQL 9.5, I have tables with columns in the form prefix_last_modified timestamp without time zone NOT NULL […]
MySQL 5.5.21 ON UPDATE CURRENT_TIMESTAMP incorrect
Question : As the title says, I’m having a few issues with ‘ON UPDATE CURRENT_TIMESTAMP’. Here is the SQL definition […]
Whether to use or not to use: DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Question : In one Database table, created_at & updated_at are defined as: `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE […]