Interested to Buy Any Domain ? << Click Here >> for more details...
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 10369 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / prasanna shejwal
TIMESTAMP DEFAULT :- when new row get inserted or existing
row get updated that time current timestamp get inserted.
CURRENT_TIMESTAMP :- when row get inserted that time current
timestamp get inserted. No change on update.
ON UPDATE CURRENT_TIMESTAMP :- when row get updated that
time current timestamp get inserted. On inserted default
value get inserted
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Can mysql scale horizontally?
What are procedures in mysql?
How to write after insert event update trigger on the same table in mysql?
How to include character strings in sql statements?
What is definer in mysql?
How to escape special characters in sql statements?
How to shut down the server with 'mysqladmin'?
In which language mysql has been written?
What is csv?
Write a query to display even rows in student table using mysql?
What is mysql url?
How do I export mysql query results to excel?
Why mongodb is faster than mysql?
How to create a table?
If we use sum function in mysql, does it return sum of that row or for that column?
