Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Fix Version/s: 10.2.1
-
Component/s: Data Definition - Create Table
-
Labels: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() |
);
|