Monday, September 3, 2012

how to use timestamp data type in more than two columns in mysql

If you use phpmyadmin and want to have two columns that hold timestamp fields, it will give you an error. We can't add more then one field as timestamp value.
Sometime, we have created_at and updated_at fields which might be timestamp column. To add these two columns as timestamp, we have alter table structure and run the following sql command:
ALTER TABLE customer_info CHANGE created_at created_at TIMESTAMP NOT NULL DEFAULT 0,
CHANGE  `updated_at`  `updated_at` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL;

At first, we set the default value of the first timestamp column as zero and set the current timestamp on second timestamp column.

See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide




List of my works:

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

No comments: