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
Can I use mariadb instead of mysql?
Will mysql remain free?
Which mysql function is used to concatenate string?
What is procedure in mysql?
What is mysql community edition?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
Is mysql a dbms?
What is a tinyint?
Which is faster innodb or myisam?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
Why should I learn mysql?
What is difference between mysqli and pdo?
How to make a copy values from one column to another in mysql?
What is msql?
Is mysql easy to learn?