Adding an auto fill row created at DateTime column

For MySQL V5.6 and above you can do this:

FirstAddedDateTime  datetime DEFAULT CURRENT_TIMESTAMP,

For earlier versions you must use timestamp and can only have 1 column defined as this:

FirstAddedDateTime  timestamp DEFAULT CURRENT_TIMESTAMP,
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *