How to use PERIOD_ADD function in MySQL

Editor to share with you how to use the PERIOD_ADD function in MySQL, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

PERIOD_ADD (month,add)

SELECT PERIOD_ADD (1601) SELECT PERIOD_ADD (191602)-> 201603-> 191605-> 191511

This function returns the result of adding or subtracting month. The format of month is yyMM or yyyyMM, and the results are all in yyyyMM format. Add can pass negative values.

The above is all the contents of the article "how to use the PERIOD_ADD function in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!