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

What happens if a table has one column defined as TIMESTAMP?

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

1 Answer

Nice?Vote!
That field gets the current timestamp whenever the row gets altered.
answered 1 year ago by R (19,530 points)

Related questions

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 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
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!
1 answer
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
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)
Powered by Question2Answer