<p>Is it possible to create a stored procedure or custom function in MariaDB / MySQL that allows me to group in a range?</p>
<p>For example I have a database of:</p>
<ul>
<li>Gender</li>
<li>Age</li>
<li>Month</li>
</ul>
<p>I want an output similar to:</p>
<table>
<thead>
<tr>
<td>month</td><td>gender</td><td>age_from</td><td>age_to</td><td>count</td></tr>
</thead>
<tbody>
<tr>
<td>01</td><td>1</td><td>10</td><td>15</td><td>500</td></tr>
</tbody>
</table>


Is it possible to create a stored procedure or custom function in MariaDB / MySQL that allows me to group in a range?

For example I have a database of:

- Gender
- Age
- Month

I want an output similar to:

| month | gender | age_from | age_to | count |
| -------- | -------- | -------- | -------- | -------- |
|  01 | 1 | 10 | 15 | 500 |


Select RANGE() in MySQL / MariaDB ?

Product

Explore

Company

Blogs

Partner with us

Support

Comparisons

Comparisons