{"type":"rich","version":"1.0","provider_name":"Hatena Blog","description":"\u3081\u3082 \u74b0\u5883 Python 3.6 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb pip install mysql-connector-python \u30b3\u30fc\u30c9 import mysql.connector as mc import pandas.io.sql as pdsql con = mc.connect( user ='USER', password='PW', host='localhost', database='DB') sql = 'SELECT * FROM table' df = pdsql.read_sql(sql, con) con.close","categories":["python"],"author_url":"https://blog.hatena.ne.jp/thr3a/","blog_url":"https://blog.turai.work/","title":"pandas\u3067MySQL\u306b\u63a5\u7d9a","provider_url":"https://hatena.blog","width":"100%","author_name":"thr3a","published":"2018-08-13 09:18:13","image_url":null,"height":"190","blog_title":"\u52d5\u304b\u3056\u308b\u3053\u3068\u30d0\u30b0\u306e\u5982\u3057","url":"https://blog.turai.work/entry/20180813/1534119493","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.turai.work%2Fentry%2F20180813%2F1534119493\" title=\"pandas\u3067MySQL\u306b\u63a5\u7d9a - \u52d5\u304b\u3056\u308b\u3053\u3068\u30d0\u30b0\u306e\u5982\u3057\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}