pandas sql execute 

from pandas.io import sql
sql.execute('SELECT * FROM table_name', engine)
sql.execute('INSERT INTO table_name VALUES(?, ?, ?)', engine, params=[('id', 1, 12.2, True)])



http://pandas.pydata.org/pandas-docs/stable/io.html#id3
posted on 2017-02-09 13:50  ppqchina  阅读(839)  评论(0)  编辑  收藏  举报