Solved MYSQL error

Discussion in 'Spigot Plugin Development' started by JustWessol, May 1, 2017.

  1. hello, i'm coding a mysql coin plugin

    but when i put the plugin into the server i will get this error:
    [​IMG] upload_2017-5-1_14-17-50.png

    i wasted an hour to get it fixed but i can't find the right syntax

    Code (Text):
    //here is the code for that line

    public static void createTable(){
            try {
                con.prepareStatement("CREATE TABLE IF NOT EXISTS coins (UUID VERCHAR(100), coins Int(16))").executeUpdate();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
     
    can somebody help me
     
  2. Change 'VERCHAR' to 'VARCHAR'
     
  3. thx why didnt i saw that