Re: Display all the records from table using cursor
No primary key, yikes. A table without a PK isn't a real table.
A candidate key is a column or set of them uniquely identifying all rows. "Candidate" means "candidate to be primary key".
The logic is inescapable. If there's no PK and no candidate key, updates cannot be guaranteed. Period.
You can waste as many hours as you like trying to square that circle, you will not succeed.
Your requirement suggests that if the tables do have a candidate key, it's so complex that it will slow updates to a crawl. Which is when auto_increment is essential. So why haven't these tables been given PKs, and in any case what stops you from adding auto_increment PKs for this job?
Let's see the result of Show Create Table for one of these tables, along with, say, five sample rows of data, so I can analyse the update requirement.
Subject
Views
Written By
Posted
4153
September 22, 2017 06:21PM
932
September 22, 2017 07:46PM
964
September 22, 2017 10:11PM
841
September 25, 2017 09:07AM
821
September 25, 2017 11:17AM
776
September 25, 2017 11:15AM
888
September 25, 2017 12:49PM
Re: Display all the records from table using cursor
802
September 25, 2017 01:18PM
708
September 25, 2017 01:36PM
697
September 25, 2017 02:00PM
702
September 25, 2017 03:51PM
818
September 25, 2017 06:24PM
721
September 26, 2017 01:34PM
775
September 26, 2017 01:56PM
682
September 26, 2017 02:22PM
788
September 26, 2017 03:35PM
723
September 27, 2017 10:28AM
838
September 27, 2017 11:39AM
796
September 26, 2017 12:43PM
759
September 26, 2017 01:27PM
720
September 26, 2017 01:44PM
833
September 25, 2017 01:46PM
832
September 25, 2017 12:56PM