By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
10.2.27-MariaDB-10.2.27+maria~jessie-log |
id | name | quantity |
---|---|---|
1 | John | 1 |
2 | Amy | 2 |
3 | Elizabeth | 3 |
FOUND_ROWS() | row_count() |
---|---|
3 | 6 |
id | name | quantity |
---|---|---|
1 | John | 4 |
2 | Elizabeth | 6 |
3 | Elizabeth | 3 |