Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
With datetime we can do:
CREATE TABLE t1 ( |
updatedTime datetime DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP() |
);
|
We should be able to use any function as a default on any data type, like this:
CREATE TABLE t1 ( |
myCol longtext DEFAULT JSON_OBJECT('a',1,'b',2), |
lottoNumber int(11) DEFAULT myUDF(), |
updatedBy varchar(255) DEFAULT CURRENT_USER() ON UPDATE CURRENT_USER() |
);
|