How to insert two datetime fields with same server time in mysql?

Question

I have a table with two fields insert_time and update_time. The type of insert_time is varchar(30) NOT NULL DEFAULT '' while the type of update_time is timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP.

insert into tableName(inser_time,update_time) values('2017-02-17 20:30:38')

will make the update_time lose its meanings.

So how to make the two fields have a same server time when inserted if not update the Mysql version?

@TimBiegeleisen for my mysql version. http://stackoverflow.com/a/17498167/1468517 — Aflext, Feb 24 '17 at 03:01

Ian Kenney · Accepted Answer · 2017-02-24T03:51:48.633

0

Just set both fields to the same value ?

insert into tableName(inser_time,update_time) 
values('2017-02-17 20:30:38','2017-02-17 20:30:38')

EDIT to use current time

insert into tableName(inser_time,update_time) 
values(now(), now())

EDIT 2 From mysql manual at: https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_now

Functions that return the current date or time each are evaluated only once per query at the start of query execution. This means that multiple references to a function such as NOW() within a single query always produce the same result.

edited Feb 24 '17 at 03:51

answered Feb 24 '17 at 02:56

Ian Kenney

6,376
1
25
44

I want the save value with server date time – Aflext Feb 24 '17 at 02:59
will the two `now()` have exact the same value ? I mean, it may take time for mysql to execute two functions. – Aflext Feb 24 '17 at 03:46
I believe that now will be evaluated once by the database engine and so, yes both should have the same value – Ian Kenney Feb 24 '17 at 03:48

How to insert two datetime fields with same server time in mysql?

1 Answers1