in MS SQL there is a command that I can issue where when used as the default value for
the fields (DateTime datatype) will generate date & time value when a new row is inserted.
CREATE TABLE [TBL_TABLE](
[fldDATE] [datetime] NULL DEFAULT (GetDate())
What would be the equivalent of GetDate() for MySQL ? How can I set a field in a table to generate
the current date when a new row is inserted ? Thanks !