MySQL Forums
Forum List  »  Stored Procedures

Re: Display all the records from table using cursor
Posted by: kaji Pasa
Date: September 25, 2017 02:00PM

master table is repository to make the mapping (match) of such incorrect records we know that will happen,and consider those to be match.so in master table if i have dog=cat and master.cc=0


What i am trying to say is ,
if b.title_sci=b.title, then we get cc=0
if b.title_sci<>b.title
then we have to see the master
if in master this m.title_sci is dog and for the same row m.title= cat then this is match as per the master(a way we say this is match though the column doesnt match in base table ).Hence i need to update cc for this row in the base table to zero which indicates this is a match.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Display all the records from table using cursor
607
September 25, 2017 02:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.