Question
VERSION_WITH_UPDATE() versus VERSION() in MySQL 9.7: what does each return?
Answer
From MySQL 9.7.4, VERSION_WITH_UPDATE() returns the four-part MAJOR.MINOR.PATCH.UPDATE identity, including an update value of 0. VERSION() still returns the three-part compatibility version. Use the former to distinguish separately delivered updates on one patch line. Applies to MySQL only.