mysql - Table insert unexisting values -
current situation tblgamepoints id gamenumber playerid game points ----------------------------------------------- 1 1 fps 150 2 1 b fps 150 3 2 fps 100 4 2 b fps 75 when starting gamenumber 3 add empty rows of game in case not allready have points (penalty points). example 1: id gamenumber playerid game points ----------------------------------------------- 1 1 fps 150 2 1 b fps 150 3 2 fps 100 4 2 b fps 75 in example above, there aren't existing rows gamenumber 3 insert statement should insert games points 0 playerids example 2: id gamenumber playerid game points ----------------------------------------------- 1 1 fps 150 2 1 b fps ...