Problem: There is neither division (÷) nor set difference () i MySQL, so you are The outmost selection will decide which columns (matr, namn) we shall see in the outmost select – from – where will create a table including all the female

MySQL ALTER TABLE does not have IF EXISTS specification. ALTER TABLE test ADD COLUMN IF NOT EXISTS column_a VARCHAR(255); Bonus, it works for MODIFY as well.

Please check if it ll work. JSFiddle: click here. Thanks Pranav