Separate data in table

0

I'd like to make a separate table for "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  |

I would like it to be just a table, is it possible? If so how can I do it?

    
asked by anonymous 10.06.2017 / 23:23

1 answer

1

Just add one more column, right? How would you look:

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

And when to select:

SELECT * FROM estatisticas ORDER BY temporada ASC;
    
10.06.2017 / 23:36