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
How would you get the current date in mysql?
How do you restart mysql?
What is pdo in php mysql?
How many types of indexes are there in mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How to copy data from one server to another using php?
How show all tables in mysql query?
How to enter numeric values as hex numbers?
Explain the different types of mysql joins.
What is database in php mysql?
What is sql in mysql?
What does innodb stand for?
How to Set a root password if there is on root password.
How many columns can you create for an index?
What are programming functions?