986Questions
785Answers
Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

Nice?Vote!
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)

1 Answer

Nice?Vote!
On initialization places a zero in that column, on future updates puts the current value of the timestamp in.
answered 1 year ago by R (19,530 points)

Related questions

Nice?Vote!
1 answer
Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
What if you really want to store the timestamp data, such as the publication date of the article?
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)
Nice?Vote!
2 answers
If you specify the data type as DECIMAL (5,2), what’s the range of values that can go in this table?
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)
Powered by Question2Answer