mysql怎样设置简写

SELECT u.id, u.name, o.order_id
FROM users u
JOIN orders o ON u.id = o.user_id;

PREPARE stmt FROM 'SELECT * FROM users WHERE id = ?';
SET @id = 1;
EXECUTE stmt USING @id;
DEALLOCATE PREPARE stmt;

DELIMITER //
CREATE PROCEDURE GetUserById(IN userId INT)
BEGIN
    SELECT * FROM users WHERE id = userId;
END //
DELIMITER ;

CALL GetUserById(1);

CREATE VIEW user_orders AS
SELECT u.id, u.name, o.order_id
FROM users u
JOIN orders o ON u.id = o.user_id;

SELECT * FROM user_orders WHERE id = 1;

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

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)

engine = create_engine('mysql://user:password@host/database')
Session = sessionmaker(bind=engine)
session = Session()

user = session.query(User).filter_by(id=1).first()
print(user.name)