cursor definition
Hi... I am new to MySQL and trying to write some database queries. (Basically, I am developing a WEB application using Pearl script. The data is stored in MySQL database. Pearl scripts access the database via Pearl DBI) I could not find any info about cursor definitions in MySQL documentations. How do I write the following Oracle code in MySQL. Cursor CurPerson is Select Arstall_Godkj_Stkomp From Person Where Fodselsdato = inFDato And Personnr = inPNr;; Begin Open curPerson; Fetch CurPerson into refGodkjent; If curPerson%Found Then Thank you Yamuna _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - 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
Re: cursor definition
At 7:08 PM + 6/28/01, Yamuna Vallipuram wrote: Hi... I am new to MySQL and trying to write some database queries. (Basically, I am developing a WEB application using Pearl script. The data is stored in MySQL database. Pearl scripts access the database via Pearl DBI) I could not find any info about cursor definitions in MySQL documentations. That's likely because MySQL doesn't have cursors. Can you just run a standard DBI fetch loop? How do I write the following Oracle code in MySQL. Cursor CurPerson is Select Arstall_Godkj_Stkomp From Person Where Fodselsdato = inFDato And Personnr = inPNr;; Begin Open curPerson; Fetch CurPerson into refGodkjent; If curPerson%Found Then Thank you Yamuna -- Paul DuBois, [EMAIL PROTECTED] - 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
cursor definition
How do I define cursors in mysql as in Oracle? Here is an example in Oracle::: Cursor CurPerson is Select Arstall_Godkj_Stkomp From Person Where Fodselsdato = inFDato And Personnr = inPNr;; Begin Open curPerson; Fetch CurPerson into refGodkjent; If curPerson%Found Then How do I write this in mysql? Thank you for any help... Yamuna - 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