Hi,
Thank you for your response. Strictly we have to use mysql 4.0 only. Actually
the source data base is oracle 7.3, we need to migrate that database to mysql 4.0 . In
oracle 7.3 views/cursors are used. That is why i need an alternative for views/cursors
in mysql 4.0. We use C/C++ for Programming. could you please explain me the
alternatives for views/cursors in mysql 4.0 and how to implement those in mysql 4.0?.
Thanks,
Narasimha
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Fri 10/1/2004 12:40 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: views/cursors in mysql 4.0
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.
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.
