laika222
10/24/2016 - 9:01 PM

In mysql, creates a column called Create, which is of the type TIMESTAMP, and which defaults to a value of the current TIMESTAMP (whenever i

In mysql, creates a column called Create, which is of the type TIMESTAMP, and which defaults to a value of the current TIMESTAMP (whenever it's entered). Apparently each table can only have one column with a TIMESTAMP column set to default to Current_Timestamp?)

ALTER TABLE people2 
  ADD COLUMN Created TIMESTAMP DEFAULT CURRENT_TIMESTAMP;