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



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

Answer / amith

A default value is used on initialization, a current
timestamp is inserted on update of the row.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is the command line end user interface - mysql?

0 Answers  


How do you rename a table in mysql?

0 Answers  


What are the differences between a primary key and foreign key?

0 Answers  


What is max connection in mysql?

0 Answers  


How to use case expression?

0 Answers  






What is “i_am_a_dump” flag in mysql?

0 Answers  


How do I add a column to a table in mysql?

0 Answers  


how to repair a table in mysql?

2 Answers  


How to write query to select word java's from column employees and from emp table

1 Answers   CGI,


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  


How to calculate the difference between two time values?

0 Answers  


How can I create a database in mysql?

0 Answers  


Categories