插入mysql条目(如果不存在)，如果不存在则更新

Question

我想插入一个条目，如果它不存在，否则更新条目，我不能使用ON重复键更新，我被语法搞混了。所以我试着做这样的事：

    final String QUERY = "REPLACE INTO skills SET VALUES (" + insert(player) + ") WHERE playername = '" + player.getUsername() + "'";
    statement.execute(QUERY);

    statement.close();
    connection.close();
}

private static String insert(Player player) {
    String stringToReturn = "'" + player.getUsername() + "',";
    for (int index = 0; index < 25; index++) {
        stringToReturn += player.getSkills().getLevels()[index] + "," + ((int) player.getSkills().getXp()[index]) + ",";
    }
    stringToReturn = stringToReturn.substring(0, stringToReturn.length() - 1);
    return stringToReturn;
}

但这是不正确的语法，所以我想知道我如何能做到这一点？

玩家名是主键

Answer 1

对于重复的键更新工作，我认为正确的语法是：

"INSERT INTO skills (playerName, otherColumn) 
    VALUES ('" + player.getUsername() + "', '" + insert(player) +"')
 ON DUPLICATE KEY UPDATE otherColumn = VALUES(otherColumn)";