[BaD CopY]

How to make more tables and use it with foreign key ?

If I create players table:

| id | steamid | xp | lvl | skills |

and skills table:

| player_id | skill_1 | skill_2 | skill_3 |

how to get each skill from players table ?

[klippy]

This is a general SQL question, has nothing to do with AMXX. You will be better off searching forums and sites that are designated to SQL, as this is a rather basic question and you should be able to do it just by reading a few introductory tutorials on keys and joins.

[Airkish]

https://www.w3schools.com/sql/sql_join.asp

[aditya12]

https://www.welookups.com/sql/sql_join.html

[Bugsy]

SELECT skill_1, skill_2, skill_3

FROM tblPlayers

LEFT JOIN tblSkills
ON tblPlayers.id=tblSkills.player_id;

or

SELECT skill_1, skill_2, skill_3

FROM tblPlayers, tblSkills

WHERE tblPlayers.id=tblSkills.player_id;