Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP.
- 1 Answers
- 2962 Views
- I also Faced
- E-Mail Answers
Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP...
Answer / amith
A default value is used on initialization, a current
timestamp is inserted on update of the row.
| Is This Answer Correct ? | 1 Yes | 0 No |
More MySQL Interview Questions
What is the full meaning of mysql?
How to show table names with 'mysqlshow'?
How do I find users in mysql?
What is the insert?
What is the difference between now() and current_date()?
Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.
How is data stored in mysql?
What is action query?
What is innodb mysql?
How do you index just the first four bytes of the column?
What is maximum table size in mysql?
What is query design?
Categories
-
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)
