Mysql – Automatically add core fields to a table when created

MySQLtimestamptrigger

I was reading these articles on StackOverflow regarding triggers and created date and updated date in mysql, and was wondering whether it is possible to create a trigger that checks if these two fields are present in the create table statement, and either creates the relevant trigger, or creates the fields, as well as the trigger? I am aware that there will be some tables for which this is not relevant, but I will address that in the future.

What is the best way to set up last-modified and date-record-added fields?

adding column to all tables in a mysql database (unknown table names)

Best Answer

The feature you are asking for is called "DDL triggers".

And no, MySQL doesn't have that. So you can't do this in a trigger.

Related Solutions

Mysql – Are triggers bad for created/timestamp columns

As far as I know, this is the reason Triggers were made. To handle an event related to a change running in the DB. I don't see any reason why you shouldn't be using a Trigger. P.S. please ask your DBA of why he doesn't like Triggers, and report back. Thank you.

Postgresql: Insert trigger function fails on partial insert statement

Try this form:

 EXECUTE 'insert into ' || child || ' values ($1.*)' USING NEW;

It requires at least PostgreSQL 8.4, but previous versions ought to be retired nowadays.

An even more modern and cleaner version (quote the table's name if necessary):

 EXECUTE format('insert into %I values ($1.*)', child) USING NEW;

Best Answer

Related Solutions

Mysql – Are triggers bad for created/timestamp columns

Postgresql: Insert trigger function fails on partial insert statement

Related Question