Multiple ResultSets

Unlike a SELECT statement, a Stored Procedure returns multiple result sets. The requires different code to be used for gathering the results of a CALL in Perl, PHP, etc.

(Need specific code here or elsewhere!)

Found a mistake? Have a question or improvement idea? Let me know.

Stored routines, procedures and functions:

*Stored routines procedures and functions

*Stored procedure with IN OUT INOUT parameters

*Create a Function

*Create Procedure with a Constructed Prepare

*Multiple ResultSets

*Create a function

Table Of Contents

0Getting started with MySQL

1Limit and Offset

2Creating Databases

3Backup using mysqldump

4Table Creation

7Stored routines, procedures and functions

8Reserved Words

9String operations

12Indexes and Keys

13Date and Time Operations

15LOAD DATA INFILE

16PREPARE Statements

20Change Password

24Pivot Queries

25Configuration and tuning

26Converting from MyISAM to InnoDB

28Create New User

33Performance Tuning

36Install MySQL with Docker

38Character Sets and Collations

39MyISAM Engine

40Many-to-many Mapping table

41Using Variables

44Security via GRANTs

47MySQL LOCK TABLE

51MySQL Performance Tips

52Temporary Tables

54Customize PS1

55Dealing with sparse or missing data

56Dynamic Un-Pivot Table using Prepared Statement

59Connecting with UTF-8

60SSL Connection Setup

61Handling Time Zones

62Time with subsecond precision

63Error 1055 ONLY FULL GROUP BY

64Full-Text search

65Extract values from JSON type

66Regular Expressions

67Recover and reset default root password

69JOINS Join 3 tables

70Server Information

71Recover from lost root password