mysql insert into 时间_关于MySQL的insert添加自动获取日期的now()的用法
INSERT INTO表名
(YEAR,
USERRANGE,
DIFFICULTY,
QUESTIONTYPE,
QUESTIONFORM,
ABOUTNH,
ABOUTDY,
AREA,
DESCRIPTION,
LASTTIME,
ZUJUANTIMES,
INSERTUSER,
INSERDATE,
UPDATEUSER,
UPDATEDATE,
ISDELETE,
KNOWLEDGENUM)VALUES(22,33,
#{DIFFICULTY},
#{QUESTIONTYPE},
#{QUESTIONFORM},
#{ABOUTNH},
#{ABOUTDY},
#{AREA},
#{DESCRIPTION},
#{LASTTIME},
#{ZUJUANTIMES},
#{INSERTUSER},
#{INSERDATE},
#{UPDATEUSER},
#{UPDATEDATE},
#{ISDELETE},
#{KNOWLEDGENUM})INSERT INTOQUESTION
(YEAR,
USERRANGE,
DIFFICULTY,
QUESTIONTYPE,
QUESTIONFORM,
ABOUTNH,
ABOUTDY,
AREA,
DESCRIPTION,
LASTTIME(NOW(),'%Y-%m-%d'),
ZUJUANTIMES,
INSERTUSER,
INSERDATE(NOW(),'%Y-%m-%d'),
UPDATEUSER,
UPDATEDATE(NOW(),'%Y-%m-%d'),
ISDELETE,
KNOWLEDGENUM)VALUES(#{YEAR},
#{USERRANGE},
#{DIFFICULTY},
#{QUESTIONTYPE},
#{QUESTIONFORM},
#{ABOUTNH},
#{ABOUTDY},
#{AREA},
#{DESCRIPTION},
#{INSERTUSER= -1},
#{UPDATEUSER= -1},
#{ISDELETE= 'F'},
#{KNOWLEDGENUM= 203})INSERT INTOQUESTION
(YEAR,
USERRANGE,
DIFFICULTY,
QUESTIONTYPE,
QUESTIONFORM,
ABOUTNH,
ABOUTDY,
AREA,
DESCRIPTION,
LASTTIME,
ZUJUANTIMES,
INSERTUSER,
INSERDATE,
UPDATEUSER,
UPDATEDATE,
ISDELETE,
KNOWLEDGENUM)VALUES(#{YEAR},
#{USERRANGE},
#{DIFFICULTY},
#{QUESTIONTYPE},
#{QUESTIONFORM},
#{ABOUTNH},
#{ABOUTDY},
#{AREA},
#{DESCRIPTION},
#{NOW() },
#{INSERTUSER= -1},
#{NOW() },
#{UPDATEUSER= -1},
#{NOW() },
#{ISDELETE= 'F'},
#{KNOWLEDGENUM= 203})