It's usually a good practice to have two columns called date_created and date_updated in every table. One can always use it in application and it helps in debugging too as to when a record was created and last updated in various circumstances and contexts.




This responsibility can be given to MySQL to automatically assign current time values to these columns.

In MySQL 5.6 onwards, this can be done by setting the data type of the columns to be either date time or timestamp and creating date_created column with NOT NULL DEFAULT CURRENT_TIMESTAMP  schema and date_updated column with NOT NULL DEFAULT …

Giuseppe Maxia writes about the availability of the active development/test ("pushbuild") MySQL binaries for users—on multiple platforms.

This is a wonderful step forward in bringing greater openness to current MySQL development and in bringing greater value to the MySQL user community!  

Giuseppe Maxia writes about the availability of the active development/test ("pushbuild") MySQL binaries for users—on multiple platforms.

This is a wonderful step forward in bringing greater openness to current MySQL development and in bringing greater value to the MySQL user community!  

Giuseppe Maxia writes about the availability of the active development/test ("pushbuild") MySQL binaries for users—on multiple platforms.

This is a wonderful step forward in bringing greater openness to current MySQL development and in bringing greater value to the MySQL user community!