import sqlalchemy as db
engine = engine = db.create_engine("mysql+pymysql://아이디:패스워드@아이피:포트/데이터베이스이름",encoding='utf8')
conn = engine.connect()
metadata = db.MetaData()
# select stock
stockTable = db.Table('stock', metadata, autoload=True, autoload_with=engine)
selectQuery = db.select([stockTable])\
.where(stockTable.columns.code.like('3575%'))
print(selectQuery)
# 쿼리 실행
result_proxy = conn.execute(selectQuery)
result_set = result_proxy.fetchall()
for obj in result_set:
print(obj[0], obj)