What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?
- 1 Answers
- 4534 Views
- I also Faced
- E-Mail Answers
What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?..
Answer / amith
On initialization places a zero in that column, on future
updates puts the current value of the timestamp in.
| Is This Answer Correct ? | 4 Yes | 0 No |
More MySQL Interview Questions
What is the difference between primary and unique key
How do I start mysql in mysql workbench?
How do I connect to a mysql database?
How to Join tables on common columns.
How can an index be declared in mysql?
What is append query?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What is the use of mysqli_connect in php?
What are views in mysql?
Is mysql a programming language?
Where is the mysql config file?
How to see the create table statement of an existing table?
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)
