Interested to Buy Any Domain ? << Click Here >> for more details...
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP .
- 2 Answers
- 10161 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 are the advantages of a procedure?
How do I free up space in mysql?
all the queries used in sql
Why do we use views instead of tables?
Explain timestamp?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
What is pdo mysql?
How to calculate expressions with sql statements?
Is mysql an oracle product?
Why is the basic difference between left join, right join and inner join?
Which is faster innodb or myisam?
How to change a password for an existing user via mysqladmin?
what is a cursor? : Mysql dba
What is the limitation of mysql?
How do I clear a mysql database?
