\u0412 \u044d\u0442\u043e\u0439 \u0437\u0430\u043c\u0435\u0442\u043a\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043a\u0430\u043a \u043f\u0440\u043e\u0441\u0442\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 MySQL \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043d\u0430 Python. \u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438 \u0432\u044b\u0432\u0435\u0434\u0435\u043c \u0435\u0435 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u043e\u0433\u043e \u0441\u043a\u0440\u0438\u043f\u0442\u0430.\u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0432 MySQL:<\/p>\n
CREATE TABLE `users` (\r\n `id` int(11) NOT NULL AUTO_INCREMENT,\r\n `email` varchar(255) COLLATE utf8_bin NOT NULL,\r\n `password` varchar(255) COLLATE utf8_bin NOT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin\r\nAUTO_INCREMENT=1 ;<\/pre>\n\u0422\u0435\u043f\u0435\u0440\u044c \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0442\u0430\u043a\u043e\u0439 \u0441\u043a\u0440\u0438\u043f\u0442 \u043d\u0430 Python<\/a><\/p>\n
import pymysql.cursors\r\n\r\n# Connect to the database\r\nconnection = pymysql.connect(host='localhost',\r\n user='user',\r\n password='passwd',\r\n database='db',\r\n charset='utf8mb4',\r\n cursorclass=pymysql.cursors.DictCursor)\r\n\r\nwith connection:\r\n with connection.cursor() as cursor:\r\n # Create a new record\r\n sql = \"INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)\"\r\n cursor.execute(sql, ('webmaster@python.org', 'very-secret'))\r\n\r\n # connection is not autocommit by default. So you must commit to save\r\n # your changes.\r\n connection.commit()\r\n\r\n with connection.cursor() as cursor:\r\n # Read a single record\r\n sql = \"SELECT `id`, `password` FROM `users` WHERE `email`=%s\"\r\n cursor.execute(sql, ('webmaster@python.org',))\r\n result = cursor.fetchone()\r\n print(result)<\/pre>\n\u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0441\u043a\u0440\u0438\u043f\u0442 \u0438 \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0432\u044b\u0432\u043e\u0434:<\/p>\n
{<\/span>'id'<\/span>:<\/span> 1<\/span>,<\/span> 'password'<\/span>:<\/span> 'very-secret'<\/span>}\r\n<\/span><\/pre>\n