Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
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 |
Restore database (or database table) from backup.
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 Answers E2 Solutions, Tesco,
How do I start mysql database?
How do I use mysql?
How To see all the tables from a database of mysql server.
What tools available for managing mysql server?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
What is mysql uuid?
In which language it is written?
What is mysql default port number?
Is mariadb faster than mysql?
Do I need python for mysql?