sqlalchemy mysql创建表_使用sqlalchemy创建mysql数据库(Creating a mysql database using sqlalchemy)...

I’m trying to create a mysql database using sqlalchemy.

I have a flask web app which contains an sqlite database. I’m trying to switch over to mysql. I’m fairly new to sqlalchemy and have learned how to create databases via sqlalchemy. However the databases were sqlite databases. I’m trying to use sqlalchemy to create a mysql database and after reading multiple posts i still can’t seem to get it.

I’ve also installed python-mysqldb

Snippets of the original code used to create an sqlite database which was successful.

Base = declarative_base()

class Categories(Base):

__tablename__ = 'categories'

id = Column(Integer, primary_key=True)

name = Column(String, unique=True)

image = Column(String)

link = Column(String)

description = Column(String)

if __name__ =='__main__':

engine = c