理工酷

内容 有两张表，一张作者，一张古诗

%load_ext sql
%sql mysql+pymysql://root:12345678@127.0.0.1/tang_poetry

'Connected: root@tang_poetry'

%sql SHOW tables;

 * mysql+pymysql://root:***@127.0.0.1/tang_poetry
2 rows affected.

例子 查看唐朝写诗歌最多的人

%%sql

SELECT
    poets.name,
    COUNT(poetries.id) AS poetries_count
FROM
    poetries
LEFT JOIN poets ON poets.id = poetries.poet_id
GROUP BY
    poets.id
ORDER BY
    poetries_count
DESC
LIMIT 10

* mysql+pymysql://root:***@127.0.0.1/tang_poetry
10 rows affected.

via:https://github.com/hxgdzyuyi/tang_poetry