Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
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 does triggers work in mysql?
What is mysql good for?
Which mysql function is used to concatenate string?
What is timestamp in mysql?
What is inner join in mysql?
How to update a root password.
Is mysql a free database?
In which year mysql created?
How to find out the second largest element from mysql table
What is procedure in mysql?
what is the main difference between myisam and innodb
Write a command to view mysql database table structure?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)