Type name | Support | Remarks |
---|---|---|
BOOL (BOOLEAN) | Yes | Alias of tinyint(1) |
BIT | Limited | |
TINYINT | Yes | |
TINYINT UNSIGNED | Limited | |
MEDIUMINT | Yes | |
MEDIUMINT UNSIGNED | Limited | |
SMALLINT | Yes | |
SMALLINT UNSIGNED | Limited | |
INT (INTEGER) | Yes | |
INT UNSIGNED (INTEGER UNSIGNED) | Limited | |
BIGINT | Yes | |
BIGINT UNSIGNED | Limited | |
FLOAT | Limited | |
FLOAT UNSIGNED | Limited | |
DOUBLE (REAL) | Limited | |
DOUBLE UNSIGNED (REAL UNSIGNED) | Limited | |
DECIMAL (NUMERIC) | Yes | |
DECIMAL UNSIGNED (NUMERIC UNSIGNED) | Limited | |
DATE | Limited | |
DATETIME | Limited | |
TIMESTAMP | Limited | |
TIME | Limited | |
YEAR | Limited | |
CHAR | Limited | |
VARCHAR | Limited | |
BINARY | Yes | |
VARBINARY | Yes | |
TINYBLOB | Yes | |
TINYTEXT | Limited | |
BLOB | Yes | |
TEXT | Limited | |
MEDIUMBLOB | Yes | |
MEDIUMTEXT | Limited | |
LONGBLOB | Yes | |
LONGTEXT | Limited | |
ENUM | Limited | |
SET | Limited | |
JSON | No |
Exception name | Cause | Actions |
---|---|---|
com.mysql.cj.jdbc.exceptions.CommunicationsException | Cannot connect to the database. | Check the [Hostname] and [Port number]. |
java.sql.SQLNonTransientConnectionException | ||
java.sql.SQLSyntaxErrorException
Unknown database '<database name>' |
The database does not exist. | Make sure the specified [Database name] exists. |
java.sql.SQLException
Access denied for user '<username >'@'< terminal name>' (using password: YES) |
Connected to the database but cannot login. | Check that the correct [User name] and [Password] is specified. |
java.sql.SQLSyntaxErrorException
Table '<table name>' doesn't exist |
The table does not exist. | Make sure the specified [Table name] exists. |