Re: How to rename column on MySQL without deleting existing data?

2019-08-29 Thread Mike
Thanks it worked! *models.py* class Experiments(db.Model): id = db.Column(db.Integer, primary_key=True) kountry = db.Column(db.String(100)) #countryland = db.Column(db.String(100)) *migration file* from alembic import op import sqlalchemy as sa from sqlalchemy.dialects import

Re: How to rename column on MySQL without deleting existing data?

2019-08-27 Thread Mike Bayer
On Tue, Aug 27, 2019, at 6:15 AM, Mike wrote: > *Setup:* > mysql> SELECT version(); > > * 5.7.27-0ubuntu0.18.04.1 > * Python 3.6.8 > * SQLAlchemy 1.3.6 > * Alembic 1.0.11 > > > *models.py:* > class Experiments(db.Model): > id = db.Column(db.Integer, primary_key=True) > # country =