MySQL / MariaDB DBA

What's new in the current version

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.

This is 22 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples