Separate data in table

Question

I would like to make a table separated by "seasons". Example:

Tabela estatisticas:
Temporada 1:
    ID | JOGADOR | PTS | AST |
    0  | Leonard | 12  | 7   |
    1  | Pedro   | 10  | 5   |
    Temporada 2:
    ID | JOGADOR | PTS | AST |
    0  | Leonard | 08  | 02  |
    1  | Pedro   | 09  | 03  |

Would you like it to be just a table, is that possible? If yes how can I do?

Answer 1

Just add an extra column, huh? How would it look:

ALTER TABLE estatisticas ADD COLUMN 'temporada' INT(1) NOT NULL FIRST;

And when you go to select:

SELECT * FROM estatisticas ORDER BY temporada ASC;