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
You must be logged in to post a comment.
Grab the RSS feed for Free Updates!(What's this? — Learn more about RSS)
Copyright © 2015 KA's Blog. All rights reserved.
Proudly powered by WordPress