from sqlalchemy import create_engine
from sqlalchemy import insert
from sqlalchemy import Table, MetaData, Column, Integer, String
 
 
#print(sqlalchemy.__version__)
engine = create_engine("mysql+pymysql://root:@localhost/test")
 
meta = MetaData()
users_table = Table(
    'users',
    meta,
    Column('user_id', Integer, primary_key=True),
    Column('nickname', String),
    Column('password', String),
    Column('email', String)
 
)
 
stmt = users_table.insert()
stmt = users_table.insert().values(
    nickname="spongebob",
    password="3R4T54%%sdFS7S",
    email='anyuser2@gmail.com',
)
 
conn = engine.connect()
 
result = conn.execute(stmt)