jawdatls/date_update.sql

Created November 2, 2015 07:02

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jawdatls/eca447a599159c9f7f59.js"></script>
Save jawdatls/eca447a599159c9f7f59 to your computer and use it in GitHub Desktop.

Download ZIP

mysql query to update only month in date

Raw

date_update.sql

	UPDATE `tbl`
	SET `date` = DATE_ADD(`date`, INTERVAL -1 MONTH)
	WHERE MONTH(`date`) = 11

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment