Views and Cursors are not available in MySQL 4.x. Usually your scripting language handles cursors for you (having them in 4.x would do you little good as stored procedures don't exist yet. Look at the current 5.x development for cursors and stored procedures). What language do you script/program with?
What would you like to have done with your views and/or cursors if they _were_ available? Workarounds exist for almost every purpose but some of them use language-specific or library-specific options. Shawn Green Database Administrator Unimin Corporation - Spruce Pine <[EMAIL PROTECTED]> wrote on 09/30/2004 03:01:51 PM: > > Hi, > How to implement views/cursors in mysql 4.0?. Normally in > mysql how the selected data is maintained in the recordsets?. Is > there any other alternatives to implement views/cursors in mysql 4. > 0?. Please advise me for the better solution. > > Thanks, > Narasimha > > > > Confidentiality Notice > > The information contained in this electronic message and any > attachments to this message are intended > for the exclusive use of the addressee(s) and may contain > confidential or privileged information. If > you are not the intended recipient, please notify the sender at > Wipro or [EMAIL PROTECTED] immediately > and destroy all copies of this message and any attachments.
