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

What if you really want to store the timestamp data, such as the publication date of the article?

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

1 Answer

Nice?Vote!
Create two columns of type TIMESTAMP and use the second one for your real data.
answered 1 year ago by R (19,530 points)

Related questions

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!
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)
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
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