- 论坛徽章:
- 0
|
在oracle或者sqlserver中,可以有几个列的默认值都为getdate()或者sysdate.
但是在mysql中只能有一个列的默认值为now().
create table W_D_SHIPPING_BOX
(
FACILITY varchar(15) not null,
SITE varchar(10) not null,
SALES_ORDER varchar(15) not null,
LINE_NO varchar(15) not null,
SHIPPING_BOX_NO varchar(30) not null,
CURRENT_QTY int not null,
MAX_QTY int not null,
DATE_TM timestamp not null default now(),
DATE_SYS timestamp not null default now(),
CREATOR national varchar(30) not null,
MODIFIER national varchar(30) not null,
primary key (FACILITY, SITE, SALES_ORDER, LINE_NO, SHIPPING_BOX_NO),
key UNIQUE_W_D_SHIPPING_BOX (SHIPPING_BOX_NO)
)ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_bin;
假如我有这个需求,应该怎么实现呢? |
|