So you must commit to save # your changes. execute ( sql, (, 'very-secret' )) # connection is not autocommit by default. cursor () as cursor : # Create a new record sql = "INSERT INTO `users` (`email`, `password`) VALUES ( %s, %s )" cursor. DictCursor ) with connection : with connection. connect ( host = 'localhost', user = 'user', password = 'passwd', database = 'db', cursorclass = pymysql. The following examples make use of a simple table CREATE TABLE ` users ` ( ` id ` int ( 11 ) NOT NULL AUTO_INCREMENT, ` email ` varchar ( 255 ) COLLATE utf8_bin NOT NULL, ` password ` varchar ( 255 ) COLLATE utf8_bin NOT NULL, PRIMARY KEY ( ` id ` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin AUTO_INCREMENT = 1 import pymysql.cursors # Connect to the database connection = pymysql. To use MariaDB's "ed25519" authentication method, you need to installĪdditional dependency: $ python3 -m pip install PyMySQL You need to install additional dependency: $ python3 -m pip install PyMySQL
To use "sha256_password" or "caching_sha2_password" for authenticate, You can install it with pip: $ python3 -m pip install PyMySQL This package contains a pure-Python MySQL client library, based on PEP
0 kommentar(er)
