Re: Insert data if it is not existing

On Wednesday, May 23, 2018, tango ward <tangoward15@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.