Having both a Created and Last Updated timestamp columns in MySQL 4.0

by

From the MySQL 5.5 documentation:

One TIMESTAMP column in a table can have the current timestamp as the default value for initializing the column, as the auto-update value, or both. It is not possible to have the current timestamp be the default value for one column and the auto-update value for another column.

Changes in MySQL 5.6.5:

Previously, at most one TIMESTAMP column per table could be automatically initialized or updated to the current date and time. This restriction has been lifted. Any TIMESTAMP column definition can have any combination of DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses. In addition, these clauses now can be used with DATETIME column definitions. For more information, see Automatic Initialization and Updating for TIMESTAMP and DATETIME.

More Related Contents:

  1. Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
  2. MySQL CURRENT_TIMESTAMP on create and on update
  3. How to use GROUP_CONCAT in a CONCAT in MySQL
  4. How can I tell when a MySQL table was last updated?
  5. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  6. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  7. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  8. How to use LOAD_FILE to load a file into a MySQL blob?
  9. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  10. On duplicate key ignore? [duplicate]
  11. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  12. Determine Rank based on Multiple Columns in MySQL
  13. When to use SELECT … FOR UPDATE?
  14. BULK INSERT in MYSQL
  15. Setting column values as column names in the SQL query result
  16. Count table rows
  17. MYSQL sum() for distinct rows
  18. How to lock a single row
  19. How to get current date & time in MySQL?
  20. Laravel join with 3 Tables
  21. MySQL Insert & Joins
  22. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  23. How to join two tables using a comma-separated-list in the join field
  24. How do I split the output from mysqldump into smaller files?
  25. How to regex in a MySQL query
  26. How to remove duplicate entries from a mysql db?
  27. Syntax error on MERGE statement
  28. Laravel MySql DB Connection with SSH
  29. Get column sum and use to calculate percent of total (mySQL)
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment