pandas讀取MySql/SqlServer資料

用過的東西總是會忘記，尤其是細節，還是記下來比較靠譜。

讀取MySql資料

1  import MySQLdb
2  import pandas as pd
3  
4  conn = MySQLdb.connect(host = host,port = port,user = username,passwd = password,db = db_name)
5  df = pd.read_sql('select * from table_name',con=conn)
6  conn.close()       

讀取SqlServer資料

1 import pymssql
2 
3 conn = pymssql.connect(host=host, port=port ,user=username, password=password, database=database)
4 df = pd.read_sql("select * from table_name",con=conn)
5 conn.close()