{"id":781,"date":"2019-05-11T16:03:09","date_gmt":"2019-05-11T13:03:09","guid":{"rendered":"https:\/\/skilx.cc\/unlix\/?p=781"},"modified":"2019-10-28T20:05:53","modified_gmt":"2019-10-28T17:05:53","slug":"%d1%80%d0%b0%d0%b1%d0%be%d1%82%d0%b0-%d1%81-mysql-%d0%b2-python","status":"publish","type":"post","link":"https:\/\/skilx.cc\/unlix\/%d1%80%d0%b0%d0%b1%d0%be%d1%82%d0%b0-%d1%81-mysql-%d0%b2-python\/","title":{"rendered":"\u0420\u0430\u0431\u043e\u0442\u0430 \u0441 MySQL \u0432 Python"},"content":{"rendered":"

MySQL \u043f\u043e-\u043f\u0440\u0435\u0436\u043d\u0435\u043c\u0443 \u043e\u0441\u0442\u0430\u0451\u0442\u0441\u044f \u043b\u0438\u0434\u0435\u0440\u043e\u043c \u0441\u0440\u0435\u0434\u0438 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 (OpenSource), \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0434\u0430\u0432\u0430\u0439\u0442\u0435 \u0443\u0437\u043d\u0430\u0435\u043c \u043a\u0430\u043a \u0441 \u043d\u0435\u0439 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0447\u0435\u0440\u0435\u0437 Python.<\/p>\n

\u041c\u044b \u0431\u0443\u0434\u0435\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043c\u043e\u0434\u0443\u043b\u044c pymysql. \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c \u0435\u0433\u043e:<\/p>\n

$ pip install pymysql<\/code><\/p>\n

\u0422\u0435\u043f\u0435\u0440\u044c \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0442\u0435\u0441\u0442\u043e\u0432\u0443\u044e \u0431\u0430\u0437\u0443, \u043d\u043e\u0432\u043e\u0433\u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f, \u0434\u0430\u0434\u0438\u043c \u0435\u043c\u0443 \u043f\u0440\u0430\u0432\u0430 \u043d\u0430 \u0431\u0430\u0437\u0443, \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438 \u043d\u0430\u043f\u043e\u043b\u043d\u0438\u043c \u0435\u0435 \u0434\u0430\u043d\u043d\u044b\u043c\u0438. \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u0441\u044f \u043a mysql:<\/p>\n

$ mysql -uroot -p<\/code><\/p>\n

mysql> create database demobase;
\nmysql> use demobase;
\nmysql> grant all on demobase.* to usr@localhost;
\nmysql> create table t1 (id int, fname varchar(100), lname varchar(100), age int);
\nmysql> insert into t1 (id, fname, lname, age) values (1, 'Ivan', 'Ivanov', 50);
\nmysql> insert into t1 (id, fname, lname, age) values (2, 'Petr', 'Petrov', 35);
\nmysql> insert into t1 (id, fname, lname, age) values (3, 'Aleksandr', 'Aleksandrov', 28);
\nmysql> SELECT * FROM `t1`;<\/code><\/p>\n

\u041f\u043e\u043b\u0443\u0447\u0438\u043c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0435:<\/p>\n

+----+-----------+-------------+-----+
\n| id | fname | lname | age |
\n+----+-----------+-------------+-----+
\n| 1 | Ivan | Ivanov | 50 |
\n| 2 | Petr | Petrov | 35 |
\n| 3 | Aleksandr | Aleksandrov | 28 |
\n+----+-----------+-------------+-----+
\n3 rows in set (0.00 sec)<\/code><\/p>\n

\u041e\u0442\u043b\u0438\u0447\u043d\u043e. \u0422\u0435\u043f\u0435\u0440\u044c \u043f\u0435\u0440\u0435\u0439\u0434\u0435\u043c \u043a Python. \u041f\u043e\u043f\u0440\u043e\u0431\u0443\u0435\u043c \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0438\u0442\u044c\u0441\u044f \u043a \u0431\u0430\u0437\u0435:<\/p>\n

import pymysql
\nconnection = pymysql.connect('localhost', 'usr', 'pa$$word', 'demobase')
\nprint (\"Connect successful!\")<\/code><\/p>\n

\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c. \u041f\u043e\u043b\u0443\u0447\u0438\u043b\u0438 «Connect successful!». \u0418\u0434\u0435\u043c \u0434\u0430\u043b\u044c\u0448\u0435. \u041f\u0440\u043e\u0447\u0438\u0442\u0430\u0435\u043c \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b t1:<\/p>\n

import pymysql
\nconnection = pymysql.connect('localhost', 'usr', 'pa$$word', 'demobase')
\nwith connection.cursor() as cursor:
\n sql = \"SELECT * FROM `t1`\"
\n cursor.execute(sql)
\n for row in cursor:
\n print(row)
\nconnection.close()
\n<\/code><\/p>\n

\u041d\u0430 \u0432\u044b\u0445\u043e\u0434\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u043a\u043e\u0440\u0442\u0435\u0436\u0438:<\/p>\n

(1, 'Ivan', 'Ivanov', 50)
\n(2, 'Petr', 'Petrov', 35)
\n(3, 'Aleksandr', 'Aleksandrov', 28)<\/code><\/p>\n

\u041e\u043a. \u0422\u0435\u043f\u0435\u0440\u044c \u0432\u044b\u0432\u0435\u0434\u0435\u043c \u0442\u0435\u0445, \u043a\u0442\u043e \u0441\u0442\u0430\u0440\u0448\u0435 30 \u043b\u0435\u0442:<\/p>\n

import pymysql
\nconnection = pymysql.connect('localhost', 'usr', 'pa$$word', 'demobase')
\nwith connection.cursor() as cursor:
\n sql = \"SELECT * FROM `t1`\"
\n cursor.execute(sql)
\n for row in cursor:
\n if row[3] > 30:
\n print(row[1]+' '+row[2])
\nconnection.close()
\n<\/code><\/p>\n

\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c:<\/p>\n

Ivan Ivanov
\nPetr Petrov<\/code><\/p>\n

\u041e\u0442\u043b\u0438\u0447\u043d\u043e. \u0422\u0435\u043f\u0435\u0440\u044c \u043f\u043e\u043c\u0435\u0441\u0442\u0438\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0443. \u0414\u043e\u0431\u0430\u0432\u0438\u043c \u0435\u0449\u0435 \u043e\u0434\u043d\u043e\u0433\u043e \u0447\u0435\u043b\u043e\u0432\u0435\u043a\u0430 Gavrila Gavrilov \u0438 \u0435\u043c\u0443 \u0431\u0443\u0434\u0435\u0442 78 \u043b\u0435\u0442:<\/p>\n

import pymysql
\nconnection = pymysql.connect('localhost', 'usr', 'pa$$word', 'demobase')
\nwith connection.cursor() as cursor:
\n sql = \"INSERT INTO t1 (id, fname, lname, age) values (4, 'Gavrila', 'Gavrilov', 78);\"
\n cursor.execute(sql)
\nconnection.commit()
\nconnection.close()
\n<\/code><\/p>\n

\u0417\u0430\u043c\u0435\u0442\u0438\u043b\u0438, \u0447\u0442\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u043b\u043e\u0441\u044c connection.commit()? \u042d\u0442\u043e \u043d\u0443\u0436\u043d\u043e \u0434\u043b\u044f \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439. \u041f\u043e-\u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u043d\u0435 \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f. \u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c, \u0447\u0442\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c (\u044d\u0442\u043e \u043c\u044b \u0434\u0435\u043b\u0430\u043b\u0438 \u0432\u044b\u0448\u0435):<\/p>\n

(1, 'Ivan', 'Ivanov', 50)
\n(2, 'Petr', 'Petrov', 35)
\n(3, 'Aleksandr', 'Aleksandrov', 28)
\n(4, 'Gavrila', 'Gavrilov', 78)<\/code><\/p>\n

\u041f\u043e\u0445\u043e\u0436\u0435, \u0447\u0442\u043e \u0432\u0441\u0435 \u0445\u043e\u0440\u043e\u0448\u043e. \u0410\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u044b\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u043b\u044e\u0431\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b SQL \u0447\u0435\u0440\u0435\u0437 Python. <\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL \u043f\u043e-\u043f\u0440\u0435\u0436\u043d\u0435\u043c\u0443 \u043e\u0441\u0442\u0430\u0451\u0442\u0441\u044f \u043b\u0438\u0434\u0435\u0440\u043e\u043c \u0441\u0440\u0435\u0434\u0438 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 (OpenSource), \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0434\u0430\u0432\u0430\u0439\u0442\u0435 \u0443\u0437\u043d\u0430\u0435\u043c \u043a\u0430\u043a \u0441 \u043d\u0435\u0439 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0447\u0435\u0440\u0435\u0437 Python.<\/p>\n","protected":false},"author":1,"featured_media":782,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,919,24,917],"tags":[67,925,938,958,924,923],"class_list":["post-781","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-python","category-24","category-917","tag-mysql","tag-python","tag-python3","tag-958","tag-924","tag-923"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t