from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, DateTime, Boolean
from sqlalchemy.orm import sessionmaker

engine = create_engine('mysql://zhongming:zhongming@localhost/zhongming?charset=utf8')
Base = declarative_base()

Session = sessionmaker(bind=engine)

class Mynews(Base):
__tablename__ = 'table2'
id = Column(Integer, primary_key=True)
type = Column(String(10), nullable=False)
name = Column(String(20), nullable=False)
author = Column(String(20), nullable=False)
content = Column(String(1000), nullable=False)
view_count = Column(Integer)
public_time = Column(DateTime)
is_valid = Column(Boolean)

# Mynews.metadata.create_all(engine)

D:\python36\lib\site-packages\sqlalchemy\engine\default.py:507: Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 497")

  cursor.execute(statement, parameters)