>You are 100% correct. > >Since MySQL does not support "cursors", I always >put an auto_increment column in my tables for just >this purpose. > >(This is what other DBMS' do, they just do it behind >your back)
You're right. I use DBase IV at work and every record has an internal record number. >Unfortunately, the way MySQL really handles result >sets doesn't lend itself to simply adding a hidden >auto_increment field to each row to act as a cursor >and allow updating of rows in result sets. > >If it did, then I'm sure they would have put cursor >support in the product already. > >Ken Thanks for the help. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php