问题描述:
解决思路:
import time
import pandas as pd
from sqlalchemy import create_engine
mysql_engine=create_engine('mysql+pymysql://root:18817351931@127.0.0.1:3306/homework?charset=gbk')
print(time.clock())
sql=(
"select a.sname,group_concat(a.sname),a.sage "
" from student a"
" inner join student b on a.sage in "
" (select sage from student where a.sage=b.sage and a.sname!=b.sname)"
" group by a.sname,a.sage"
" order by a.sage"
)
pd.read_sql(sql,mysql_engine)
print(time.clock())