Adding missing timestamp column in MySQL table

Problem

You have a MySQL table that does not have any timestamp information (creating, updating) and you want to add a column that automatically adds a timestamp every time the record is created.

Solution

Add the column for timestamp that creates a timestamp every time a new record is created (INSERT) by using the following:

ALTER TABLE table_name ADD created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP

More information here