sqlalchemy 如何执行 insert into if not exists?

INSERT INTO table_listnames (name, address, tele)
SELECT * FROM (SELECT 'Rupert', 'Somewhere', '022') AS tmp
WHERE NOT EXISTS (
    SELECT name FROM table_listnames WHERE name = 'Rupert'
) LIMIT 1;

select

name

exists

SQLAlchemy

3 replies • 2021-09-14 15:21:22 +08:00

RockShake

Sep 13, 2021

https://docs.sqlalchemy.org/en/14/tutorial/data_insert.html#insert-from-select
https://docs.sqlalchemy.org/en/14/tutorial/data_select.html

这两个应该能完美解决你的问题

knightdf

Sep 14, 2021

.prefix_with('IGNORE')应该也可以解决

wuwukai007

Sep 14, 2021

@RockShake 谢谢
@knightdf 这个会导致自动 ID 不对

sqlalchemy 如何 执行 insert into if not exists?

sqlalchemy 如何执行 insert into if not exists?