Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 9008 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amith
The column exhibits the same behavior as a single timestamp
column in a table with no other timestamp columns.
| Is This Answer Correct ? | 2 Yes | 1 No |
How many queries can mysql handle?
How do I create a schema in mysql?
How to display top 10 rows in mysql?
What is difference between function and procedure in mysql?
What are triggers mysql?
Why mysql is used with php?
How do you start MySQL on Linux?
What is difference between unix timestamp and mysql timestamp?
How do you index just the first four bytes of the column?
Explain advantages of MyISAM over InnoDB?
How do I view data in mysql workbench?
What are MySQL transactions?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
