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

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP 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!
The column exhibits the same behavior as a single timestamp column in a table with no other timestamp columns.
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 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
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
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)
Powered by Question2Answer