Interested to Buy Any Domain ? << Click Here >> for more details...
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 10281 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 prepare statement in mysql?
What is the difference between truncate and delete in mysql?
Why do we use views instead of tables?
How do you create a primary key?
What is max_used_connections in mysql?
What is mysqli_num?
How do you determine the location of mysql data directory?
How do I find my mysql username and password?
What is trigger in mysql?
What is mysql shell?
What is mysqladmin flush hosts?
Does insert statement lock the table?
How to set mysql variable in php?
Does mysql scale well?
Can we save images in mysql database?
