I am creating a MySQL database and it is storing stats from a game. Right now I am just setting it up and I need to add 80 players with a column for each one that has there goals, assists, etc...
here is my code:
INSERT INTO `finalproject`.`Bremners` (
`stud_id`,
`stud_name`,
`stud_goal`,
`stud_assist`,
`stud_attendance`,
`stud_goalie`
) VALUES (
'1',
'test',
'0',
'0',
'0',
'0'
);
But that only inserts one player named "test". Does anyone know how to modify this code so that it adds 80 players each one with a different name? (I making the website with php so if it can be done through php that works to)
Thanks