Databases like SQL are designed to process bulk data (all records that match certain criteria).
When you need to process data sequentially (pretty much like for each ... next in VB) you need a cursor. Cursor will retrieve record after record (given your criteria) and allow you to handle each record separately.
Personally, I don't recall ever using a cursor for inserting data. Could you give us a little more detail about the circumstance you have in mind? Maybe post an example? If we knew a bit more we might be able to come up with a rationale or an explanation (or maybe an alternative?).
I've used a cursor to insert data. The reason was that the table receiving the data had a trigger for insert, that would handle 1 record at a time (was building a string for communication with an MVS host and was using variables. Who ever created the trigger wasn't checking the number of records in INSERTED and I just found it easier to go with the trigger than to mess the whole interface).
Other than that I can only think that the insert is based on a VERY complex ruleset that would be too much for case to handle or that would change tables/ select statements (perhaps dynamic SQL?) depending on the data received.
Oh wait, also it makes it easier to create header/detail records under some very specific circumstances (using OUTPUT when inserting header if no keys are available).
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...