Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 9658 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
How to see table's field formats or description of table .
What are the steps involved in query processing?
How do you shutdown a mysql database?
What is 'mysqlimport'?
What is text in mysql?
What is the difference between b-tree and hash indexes?
What is pragma autonomous_transaction?
What is the size of mysql database?
Restore database (or database table) from backup.
Why to use char instead of varchar in the database?
How important is to list the column names when doing an insert?
What is sqlyog?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
How many tables we can create in mysql database?
What is procedure in mysql?
