python

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)