On Wednesday, May 23, 2018, Adrian Klaver <
adrian.klaver@aklaver.com> wrote:
'''INSERT INTO my_table(name, age)
SELECT %s, %s
WHERE NOT EXISTS(SELECT name FROM my_table WHERE name=%s)''', ('Scott', 23)
I doubt that worked, you have three parameter markers(%s) and two parameter values. Not only that two of the markers are for identifiers.
The count is indeed off but the two markers after the main select are literals, not identifiers. As is the one being compared to name.
SELECT 'Scott', 23;
is a valid query.
David J.