Re: migrating multi-line SQL commands from pymysql

[q kaiwei]

I meet the same problem, using the lastest version of mysql-connector-python.

It's simple to add a parameter to the instance of engine of sqlalchemy based on pymysql.

from pymysql.constants.CLIENT import MULTI_STATEMENTS

engine = create_engine('mysql+pymysql://%s:%s@%s:%s/%s' % (DB_CFG['user'], quote_plus(DB_CFG['password']), DB_CFG['host'], DB_CFG['port'], DB_CFG['database']), connect_args={"client_flag": MULTI_STATEMENTS})