Interested to Buy Any Domain ? << Click Here >> for more details...
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 10311 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 |
Why we use mongodb instead of mysql?
What is the maximum number of records in mysql table?
What is the difference between mysql and sql?
How to find the unique values if the value in the column is repeated?
How to enter boolean values in sql statements?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
How to load a csv file into a table
What is the difference between having and where clause in mysql? Explain
What you can use regular expression for in mysql? Support your answer with an example?
How do I transfer data from one database to another in mysql?
How can I remotely connect to mysql database?
How to list or view all databases from the mysql server.
-
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)
