Mysql and java errors?

Ma
- in Plugins
4

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

co

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.

Ma

What do I have to write instead of the d (example?

co

Is on the website.

'd' is the number of decimal places.

Ma

Thank you.