I'm currently trying to write a minecraft plugin but it can't create the tablet.
Code:
ps = MySQL.getConnection (). PrepareStatement ("CREATE TABLE IF NOT EXISTS CastleBuildings (name VARCHAR (255), x DOUBLE (255), y DOUBLE (255), ruler VARCHAR (255), inhabitant INT (255), level INT (255)) ");
ps.executeUpdate ();
error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '), y DOUBLE (255), ruler VARCHAR (255), inhabitant INT (255), level INT (255))' at line 1
Please refer:
https://www.w3schools.com/sql/sql_datatypes.asp
The syntax for the data type is DOUBLE
DOUBLE (size, d)
However, you only provided one argument.
What do I have to write instead of the d (example?
Is on the website.
'd' is the number of decimal places.
Thank you.