On Thu, May 24, 2018 at 10:55 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Wednesday, May 23, 2018, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:INSERT INTO my_table(%s, %s)
WHERE NOT EXISTS(SELECT name FROM my_table WHERE name= %s)
INSERT doesn't have a where clause...David J.
What I did is
'''INSERT INTO my_table(name, age)
SELECT %s, %s
WHERE NOT EXISTS(SELECT name FROM my_table WHERE name=%s)''', ('Scott', 23)
