- About us
- Services
- Skills
- Web Development
- ColdFusion Development
- SharePoint Development
- Classic ASP Development
- ASP.NET Development
- Modern ASP .Net Development
- DotNetNuke Development
- Java/JSP/servlets Development
- Python Development
- PHP Development
- Perl Development
- Ruby on Rails (RoR) Development
- Lasso Development
- Real Basic Development
- Google API Integration Services
- Mobile Development
- Database & Client server Development
- Plug-in Development
- Reports/BI Development
- Automated Testing
- QA/Testing Skills
- Domain-based Testing
- E-Commerce Development
- CMS Development
- Desktop Development
- RIA Development
- App-based development
- Salesforce Development
- SugarCRM Development
- Dynamics GP GreatPlains development
- Dynamics SL Solomon development
- Microsoft Dynamics CRM Consulting Development
- Dynamics RMS development
- LiveCycle development
- QuickBooks development
- Drupal development
- Joomla development
- Typo3 development
- Magento development
- Dolphin social development
- Others
- Web Development
- Industries
- Knowledge
- Process
- Models
- Clients
- Career
| |
Software Technology Tips
In MySQL, inner cursor ( which means Cursor inside another Cursor) does not work properly for stored procedures. So you can use "BLOCK" in such situations. |
For example, if you want to create a stored procedure to iterate through all the records of a Master table and update related records in the Child table, the following code snippet can help you do so
BLOCK1: BEGIN
Declare the Master Cursor here...... ................................................. ................................................. OPEN MasterCursor; REPEAT FETCH .......... BLOCK2: BEGIN Declare the Child Cursor here...... ................................................. ................................................. OPEN ChildCursor; REPEAT FETCH .................................... ............................................... UNTIL .... END REPEAT; CLOSE ChildCursor; END BLOCK2; UNTIL ... END REPEAT; CLOSE MasterCursor; END BLOCK1; |
Related Tags:
Database, MySQL
Author: Rashmita Devi
Database
- Using Inner Cursor in MySQL
- Advantage of sp_executesql over Exec
- Capture identity values while inserting multiple rows in Sql Server 2005
- Bulk Copy with Oracle using Array Binding
- Some Useful Date Time conversion Tips in SQL
- Which one to use in a SQL query:-"Not Exists"/ Left Join / Not In"?
- Consuming No space for storing NULL value in table
- How to use a comma seperated list as paramater to a stored procedure
- Set the Recovery model of the database to Simple/Full
- How to create temporary table in MySQL
- How to relocate database from C#.NET (SQL Server 2000)
- Importance of Max Degree of Parallelism in SQL Server
- How to display tabular data in CLR proc
- MySQL: Ordering values according to a predefined pattern
- Use of cross apply to show ',' separated values(SQL Server)
- MYSQL:Ordering A TextField Numerically
- How to select Random rows in SQL Server using TABLESAMPLE
- How to add dynamic data in to the SQL Report header and footer
- How To Set Page Break in a report Conditionally
- MySQL: Filter or Search Records Using Regular Expression
- More Related Tips
