Written by khawaib
To increase dates in database table run following query and change INTERVAL value to desired value.
UPDATE `table_name` SET `date` = DATE_ADD(`date` , INTERVAL 365 DAY);
Posted on 3 February 2012
Tags: dates, increase date, sql, update date
Email (will not be published) (required)
Grab the RSS feed for Free Updates!(What's this? — Learn more about RSS)
Copyright © 2013 KA's Blog. All rights reserved.
Proudly powered by WordPress