How to Create Table With All Data Types in MySQL

package example.jdbc.mysql;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
 
public class CreateTableWithAllDataTypesInMySQL {
    public static Connection getConnection() throws Exception {
	String driver = "org.gjt.mm.mysql.Driver";
	String url = "jdbc:mysql://localhost/databaseName";
	String username = "root";
	String password = "root";
	Class.forName(driver);
	Connection conn = DriverManager.getConnection(url, username, password);
	return conn;
    }
 
    public static void main(String[] args) throws Exception {
	PreparedStatement pstmt = null;
	Connection conn = null;
	try {
	    StringBuffer sql = new StringBuffer("CREATE TABLE tableWithAllTypes(");
	    sql.append("column_boolean       BOOL, "); // boolean
	    sql.append("column_byte          TINYINT, "); // byte
	    sql.append("column_short         SMALLINT, "); // short
	    sql.append("column_int           INTEGER, "); // int
	    sql.append("column_long          BIGINT, "); // long
	    sql.append("column_float         FLOAT, "); // float
	    sql.append("column_double        DOUBLE PRECISION, "); // double
	    sql.append("column_bigdecimal    DECIMAL(13,0), "); // BigDecimal
	    sql.append("column_string        VARCHAR(254), "); // String
	    sql.append("column_date          DATE, "); // Date
	    sql.append("column_time          TIME, "); // Time
	    sql.append("column_timestamp     TIMESTAMP, "); // Timestamp
	    sql.append("column_asciistream1  TINYTEXT, "); // Clob ( 2^8 bytes)
	    sql.append("column_asciistream2  TEXT, "); // Clob ( 2^16 bytes)
	    sql.append("column_asciistream3  MEDIUMTEXT, "); // Clob (2^24 bytes)
	    sql.append("column_asciistream4  LONGTEXT, "); // Clob ( 2^32 bytes)
	    sql.append("column_blob1         TINYBLOB, "); // Blob ( 2^8 bytes)
	    sql.append("column_blob2         BLOB, "); // Blob ( 2^16 bytes)
	    sql.append("column_blob3         MEDIUMBLOB, "); // Blob ( 2^24 bytes)
	    sql.append("column_blob4         LONGBLOB)"); // Blob ( 2^32 bytes)
 
	    conn = getConnection();
	    pstmt = conn.prepareStatement(sql.toString());
	    pstmt.executeUpdate();
	} catch (Exception e) {
	    e.printStackTrace();
	} finally {
	    conn.close();
	}
    }
}