Interested to Buy Any Domain ? << Click Here >> for more details...
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 10302 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
What is pragma autonomous_transaction?
What is indexing in mysql?
What is clob in mysql
What is a storage engine?
How do I restore a mysql database?
How do I find mysql database?
Does facebook still use mysql?
Why are function needed?
How to use triggers to track changes in mysql?
How can you validate emails using a single query?
How do I set user privileges in mysql?
How do I select a table in mysql?
How to enable or disable a row of a table using MySQL in struts?
Does mysql scale well?
What is timestamp in mysql?
