Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 9570 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 |
Is mongodb faster than mysql?
How does mysql store data?
Where is mysql installed on linux?
what is the default port for mysql server? : Mysql dba
What is blob in mysql?
What is prepare statement in mysql?
What is the current version of mysql?
How to set the time zone for MySQL to particular country time?
What is orm in mysql?
What is the maximum size of mysql database?
What is mysqladmin flush hosts?
How do I copy a table in mysql?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
