这种 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 |