Having troubles creating a specific TRIGGER in MySQL
You need to put your code in a CREATE TRIGGER statement. 

CREATE TRIGGER AddNewUserToHighscoresTable 
    AFTER INSERT ON USER_ACCOUNTS 
    BEGIN 
         &lt;insert code to run after inserts on the USER_ACCOUNTS table here...&gt; 
    END