DEFAULT CURRENT_TIMESTAMP [duplicate]

Navigation
2

Using DEFAULT CURRENT_TIMESTAMP when done UPDATE this date will also be updated to date UPDATE ?

Or is it fixed and inserted only once at the time of INSERT ?

    
asked by anonymous 30.10.2015 / 20:26

1 answer

4

To update both the insert and the update, you need both statements: 

DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

More details on manual .

    
30.10.2015 / 22:09
On Click only works once What is the difference of bindValue for an array executed directly in $ pdo-execute ()