create table history (
ID Int AUTO_INCREMENT PRIMARY KEY,
CreateDate DateTime NULL DEFAULT 'NOW()',
LastModify DateTime NULL DEFAULT 'NOW()')
ID Int AUTO_INCREMENT PRIMARY KEY,
CreateDate DateTime NULL DEFAULT 'NOW()',
LastModify DateTime NULL DEFAULT 'NOW()')
----- ---- ---- --- ------- -----
ID int(11) PRI NULL auto_increment
CreateDate datetime YES 0000-00-00 00:00:00
LastModify datetime YES 0000-00-00 00:00:00缺省值都是0000-00-00 00:00:00!!!???
create table history (
ID Int AUTO_INCREMENT PRIMARY KEY,
CreateDate DateTime NULL DEFAULT NOW(),
LastModify DateTime NULL DEFAULT NOW())
create table history (
ID Int AUTO_INCREMENT PRIMARY KEY,
CreateDate DateTime NULL DEFAULT NOW(),
LastModify DateTime NULL DEFAULT NOW())