Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 9014 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 |
How many rows can mysql handle?
Where the database is stored in mysql?
How do you create a primary key?
What is pragma autonomous_transaction?
What is schema in mysql?
How set mysql root password?
What is the diff. bwt. primary key and unique key?
What is save point in mysql?
How To see all the tables from a database of mysql server.
How can we get the number of rows affected by query?
What is a trigger? How you can create a trigger in mysql?
all the queries used in sql
-
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)
