0

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)

Improve this question

1 Answer 1

Reset to default
2

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.

Improve this answer
3
  • So I will have to make sure to add the triggers manually. Thank you. Do you know if mariadb or postgresql have the feature?
    – JoSSte
    Commented Mar 12, 2017 at 15:07
  • Postgres has Event triggers - implemented in 9.3 - but I've never used that feature.
    – ypercubeᵀᴹ
    Commented Mar 12, 2017 at 15:14
  • @JoSSte , also - each tasks have many ways for realisation, main question - what the goals? Why You need create this? As example - MariaDB have excellent Audit Plugin (compatible with any MySQL) - it allow You audit all DDL changes, You can parse them and use this information.
    – a_vlad
    Commented Mar 12, 2017 at 21:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.