What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do?
Answer Posted / amith
On initialization places a zero in that column, on future
updates puts the current value of the timestamp in.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do I download mysql on my laptop?
How to dump a table from a database.
What is the maximum size of table in mysql?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
Can a table have multiple primary keys?
Can not connect to mysql server 10060?
Why do we use preparedstatement?
What are enums used for in mysql?
Explain the different types of mysql joins.
what is constraints? Also explain the different types of constraints?
What is ISAM?
Why phpmyadmin is used for mysql?
How do you insert a table?
Is primary key auto increment?
What is dbms in mysql?