sqlalchemy 执行原生sql语句
1、方式一
# 查询 cursor = session.execute(‘select * from users‘) result = cursor.fetchall() # 添加 cursor = session.execute(‘insert into users(name) values(:value)‘, params={"value": ‘abc‘}) session.commit() print(cursor.lastrowid)
2、方式二
conn = engine.raw_connection() cursor = conn.cursor() cursor.execute( "select * from t1" ) result = cursor.fetchall() cursor.close() conn.close()
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/21467.html
- 上一篇：sqlalchemy 外键
- 下一篇：SQL语句优化方式
