Important changes

v2.2.0 uses pkg-config instead of mysql_config. You need to install pkg-config to build. You can configure cflags and ldflags manually by setting MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS too.

Cursor.mogrify() is added.

Cursor.executemany implementation now uses mogrify(). Sequencee of scalar value (e.g. executemany("INSERT INTO t (data) VALUES (%s)", [1, 2, 3]) is no more valid args. You need to use sequence of tuple (e.g. [(1,), (2,), (3,)]) instead.

What's Changed

• Actions: Drop Python 3.6 and add 3.11-dev by @methane in https://github.com/PyMySQL/mysqlclient/pull/542
• docs: fix simple typo, portible -> portable by @timgates42 in https://github.com/PyMySQL/mysqlclient/pull/547
• Update python_requires to match supported python versions by @gopackgo90 in https://github.com/PyMySQL/mysqlclient/pull/543
• Raise ProgrammingError on -inf by @methane in https://github.com/PyMySQL/mysqlclient/pull/557
• Swap 3.11-dev for 3.11 in CI by @joshuadavidthomas in https://github.com/PyMySQL/mysqlclient/pull/561
• Add CodeQL workflow for GitHub code scanning by @lgtm-com in https://github.com/PyMySQL/mysqlclient/pull/565
• ER_BAD_NULL should be IntegrityError. by @methane in https://github.com/PyMySQL/mysqlclient/pull/579
• Update windows build workflow by @methane in https://github.com/PyMySQL/mysqlclient/pull/585
• Use pkg-config instead of mysql_config by @methane in https://github.com/PyMySQL/mysqlclient/pull/586
• Remove uneeded code. by @methane in https://github.com/PyMySQL/mysqlclient/pull/512
• Add collation option by @vsalvino in https://github.com/PyMySQL/mysqlclient/pull/564
• Start 2.2.0 development by @methane in https://github.com/PyMySQL/mysqlclient/pull/587
• Action: Use Ruff by @methane in https://github.com/PyMySQL/mysqlclient/pull/588
• Run pyupgrade --py38-plus by @methane in https://github.com/PyMySQL/mysqlclient/pull/590
• Update workflows by @methane in https://github.com/PyMySQL/mysqlclient/pull/593
• Update Django test workflow by @methane in https://github.com/PyMySQL/mysqlclient/pull/594
• CI: Update codeql build. by @methane in https://github.com/PyMySQL/mysqlclient/pull/595
• Improved exception handling when importing the module by @piglei in https://github.com/PyMySQL/mysqlclient/pull/596
• CI: Fix django workflow by @methane in https://github.com/PyMySQL/mysqlclient/pull/597
• Use pyproject.toml by @methane in https://github.com/PyMySQL/mysqlclient/pull/598
• Add Cursor.mogrify(). by @steveteahan in https://github.com/PyMySQL/mysqlclient/pull/477
• Add ability to customize ssl mode settings by @thereisnosun in https://github.com/PyMySQL/mysqlclient/pull/475
• Use src-layout. by @methane in https://github.com/PyMySQL/mysqlclient/pull/600
• Discard results without converting them into Python objects. by @methane in https://github.com/PyMySQL/mysqlclient/pull/601
• Fix sphinx warnings by @methane in https://github.com/PyMySQL/mysqlclient/pull/602
• Release GIL during result.discard() by @methane in https://github.com/PyMySQL/mysqlclient/pull/604
• Fix executemany with binary prefix by @methane in https://github.com/PyMySQL/mysqlclient/pull/605
• CI: Fix Django test by @methane in https://github.com/PyMySQL/mysqlclient/pull/606
• Fix Connection.escape() with Unicode input by @methane in https://github.com/PyMySQL/mysqlclient/pull/608
• fix: fix sslmode typo by @mschoettle in https://github.com/PyMySQL/mysqlclient/pull/609
• CI: Update Django test workflow by @methane in https://github.com/PyMySQL/mysqlclient/pull/610
• Release v2.2.0rc1 by @methane in https://github.com/PyMySQL/mysqlclient/pull/607

New Contributors

• @gopackgo90 made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/543
• @joshuadavidthomas made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/561
• @lgtm-com made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/565
• @vsalvino made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/564
• @piglei made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/596
• @steveteahan made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/477
• @thereisnosun made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/475
• @mschoettle made their first contribution in https://github.com/PyMySQL/mysqlclient/pull/609

Full Changelog: https://github.com/PyMySQL/mysqlclient/compare/v2.1.1...v2.2.0rc1