Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP.
- 1 Answers
- 3082 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 default password for mysql?
What is mysql_query?
How can a user get the current SQL version?
What is a table schema?
What is a heap table?
What is DDL in MySQL?
How to use rank function in mysql?
How can you see all indexes defined for a table?
Write a query to display even rows in student table using mysql?
How many ways we can we find the current date using MySQL?
How MySQL is different from SQL?
17 Answers HCL, IBM,
How to include comments in sql statements?
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)
