Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
Answer Posted / 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 |
Post New Answer View All Answers
What is processlist in mysql?
What is a procedure example?
How do I drop a database in mysql?
Can't connect mysql server on localhost?
How do I update a variable in mysql?
What mysql means?
Can you tell what are various ways to create an index?
What is delimiter in mysql?
How do I start mysql in mysql workbench?
What language does mysql use?
What are the advantages of myisam over innodb?
Is there a free mysql?
What are the objects can be created using CREATE statement?
What is the use of mysql workbench?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...