On Wednesday, May 23, 2018, tango ward <tangowar...@gmail.com> wrote:
> Thanks masters for responding again. > > I've tried running the code: > > INSERT INTO my_table(name, age) > SELECT name, age > WHERE NOT EXISTS(SELECT name FROM my_table WHERE name= name) > > > this doesn't give me error but it doesn't insert data either. > > I'm doubting your assertion that it doesn't error. How do you run that query such that age and name are recognized given the main query doesn't have a from clause? David J.