Solved MySQL - INSERT query

Hi there, I have a little problem. My plugin adds rows to the table, when I executed an "/irc [message]" command. BUT, the plugin doesn't add rows to the start of the table:


My code:

Code:

public synchronized static void addRowToTable(String player, String message){
        try{
            PreparedStatement sql = connection
                    .prepareStatement("INSERT INTO `ircchat_mc` VALUES (?,?);");
            sql.setString(1, player);
            sql.setString(2, message);
            sql.execute();
           
            sql.close();
           
        }catch (Exception e){
            e.printStackTrace();
        }
    }

Thanks for any solution.

PS: I'm sorry, but my english is so bad xD I'm Slovak
PS(2): I've opened the connection in "onEnable()" and closed in "onDisable()"

 

@timtower Great, and how to do it? What's the auto increment? Sorry, I'm new in MySQL

 

@timtower Do you mean id of message?

 

@timtower Okay, and why is it good for? I think it's just another column in my table, like others

 

@timtower Great idea! I'll test it!

 

edit the TABLE STRUCTURE, and look in id for auto_increment, check the tick and accept.

 

@elraro @timtower Many thanks! That's what I need! TYYY