mysql - Insert if not exit else skip -


before inserting movie details trying check if movie details presnt in db or not. if details present not insert nor update.i want skip .

insert jos_movie (movie_name, language, cast,movie_release,director,rating,rating_count,movie_ids) select * (select 'test','null','yahoo','dec 21, 2012','himmat',250,230,'43677') tmp not exists (     select movie_name jos_movie movie_name = 'yahoo') 

with above query value getting update everytime running it. not checking. wrong in this?

thanks got answer

i inserting test movie not yahoo !. thats stupid of me. thanks


Comments