I can't find what the syntax looks like for adding a DATETIME column to a mysql table when I want to set the default to - example - 2011-01-26 14:30:00
Does anyone know what that syntax looks like?
Here's what I've got
ADD COLUMN new_date DATETIME AFTER preceding_col,
Thanks
解决方案
ALTER TABLE yourTable
ADD COLUMN new_date DATETIME NOT NULL DEFAULT 20110126143000 AFTER preceding_col
or
ALTER TABLE yourTable
ADD COLUMN new_date DATETIME NOT NULL DEFAULT '2011-01-26 14:30:00' AFTER preceding_col
(I just prefer the numeric DATETIME format)