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

Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.

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

1 Answer

Nice?Vote!
A default value is used on initialization, a current timestamp is inserted on update of the row.
answered 1 year ago by R (19,530 points)

Related questions

Nice?Vote!
1 answer
What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
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
What happens if a table has one column defined as TIMESTAMP?
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)
Nice?Vote!
1 answer
Explain the difference between FLOAT, DOUBLE and REAL.
asked 1 year ago in MySQL Interview Questions and Answers by R (19,530 points)
Powered by Question2Answer