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
Post a Comment