On Wednesday, May 23, 2018, Adrian Klaver <adrian.kla...@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.
