On Thu, May 24, 2018 at 10:55 AM, David G. Johnston < [email protected]> wrote:
> On Wednesday, May 23, 2018, Adrian Klaver <[email protected]> > 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)
