Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How do I download mysql on my laptop?

888


How to dump a table from a database.

1019


What is the maximum size of table in mysql?

1028


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?

1908


Can a table have multiple primary keys?

901


Can not connect to mysql server 10060?

920


Why do we use preparedstatement?

916


What are enums used for in mysql?

1003


Explain the different types of mysql joins.

925


what is constraints? Also explain the different types of constraints?

971


What is ISAM?

1111


Why phpmyadmin is used for mysql?

942


How do you insert a table?

926


Is primary key auto increment?

946


What is dbms in mysql?

969