i think you should not create a table for each player. Only I suggest that you add a 'player ID' column (and also unique ID – Primary Key) to the players table as well. You may also create a teams table. And finally maybe also consider if the table structure can handle if a players changes from one tam to another?
SQLyog can help you (easily) to create what tables you want. But it cannot decide how the tables should be.