
这种 sql,怎么用 sqlalchemy 写?
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; 1 RockShake Sep 13, 2021 |
2 knightdf Sep 14, 2021 .prefix_with('IGNORE')应该也可以解决 |
3 wuwukai007 OP |