CREATE TABLE IF NOT EXISTS jj_test (
  id BIGINT NOT NULL PRIMARY KEY
, f_tinyint TINYINT
, f_short   SMALLINT 
, f_int	    INT
, f_long    BIGINT
, f_float   FLOAT
, f_double  DOUBLE
, f_decimal DECIMAL(9,3)
, f_varchar VARCHAR(20)
);

INSERT INTO jj_test VALUES
 ( 1, 1, 1, 1, 1, 1.1, 1.11, 1.111, "1.1111")
,( 2, 2, 2, 2, 2, 2.2, 2.22, 2.222, "2.2222")
,( 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) 
,( 4, 4, 4, 4, 4, 4.4, 4.44, 4.444, "4.444")
,( 5, 5, 5, 5, 5, 5.5, 5.55, 5.555, "5.555")
;