Interested to Buy Any Domain ? << Click Here >> for more details...
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 10184 Views
- Zensar, I also Faced
- E-Mail Answers
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 mysql default database?
What is user in mysql?
What is myisamchk?
What are the difference between now and current_date in mysql?
What do you mean by % and _ in the LIKE statement?
What is a transaction? Describe mysql transaction properties.
What are different types of queries?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
How do I create a mysql database?
What is acid in mysql?
What does innodb stand for?
Is oracle better than mysql?
How to create a table index in mysql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
