Incorrect SQL Syntax

When i execute an sql, the following error occurs.

Code:

[12:51:25 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc VARCHAR(100), uuid VARCHAR(40) NOT NULL)' at line 1
[12:51:25 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[12:51:25 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[12:51:25 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[12:51:25 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[12:51:25 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[12:51:25 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:408)
[12:51:25 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
[12:51:25 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[12:51:25 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[12:51:25 WARN]:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[12:51:25 WARN]:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[12:51:25 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[12:51:25 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
[12:51:25 WARN]:        at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
[12:51:25 WARN]:        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
[12:51:25 WARN]:        at com.rcextract.minecord.DatabaseManager.init(DatabaseManager.java:65)
[12:51:25 WARN]:        at com.rcextract.minecord.Minecord.onEnable(Minecord.java:54)
[12:51:25 WARN]:        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264)
[12:51:25 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
[12:51:25 WARN]:        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:402)
[12:51:25 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:378)
[12:51:25 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:327)
[12:51:25 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.reload(CraftServer.java:749)
[12:51:25 WARN]:        at org.bukkit.Bukkit.reload(Bukkit.java:525)
[12:51:25 WARN]:        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25)
[12:51:25 WARN]:        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
[12:51:25 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:645)
[12:51:25 WARN]:        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchServerCommand(CraftServer.java:631)
[12:51:25 WARN]:        at net.minecraft.server.v1_12_R1.DedicatedServer.aP(DedicatedServer.java:443)
[12:51:25 WARN]:        at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:406)
[12:51:25 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:678)
[12:51:25 WARN]:        at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:576)
[12:51:25 WARN]:        at java.lang.Thread.run(Unknown Source)

It says the syntax is wrong, but idk how to fix it. Here is the sql:

Code:

CREATE TABLE users (id INT UNSIGNED NOT NULL, name VARCHAR(16) NOT NULL, nickname VARCHAR(16) NOT NULL, desc VARCHAR(100), uuid VARCHAR(40) NOT NULL);

Any ideas?

 

@RcExtract
Sometime some names of row will not work, maybe they are reserved. Try to change them and see if u still get an error.
You have to put the primary key also.