数据库mysql建表flink支持的字段集，insert插入数据_flink mysql table 字段对应-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_44236758/article/details/134881494

本文展示了如何在Flink中创建一个包含多种数据类型的表，如整数、浮点数、日期时间等，并插入具体值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

drop table all_flink_type;
CREATE TABLE all_flink_types17 (
    TINYINT_test	TINYINT
    ,SMALLINT_test	SMALLINT
    ,TINYINT_UNSIGNED_test	TINYINT UNSIGNED
    ,INT_test	INT
    ,MEDIUMINT_test	MEDIUMINT
    ,SMALLINT_UNSIGNED_test	SMALLINT UNSIGNED
    ,INT_UNSIGNED_test	INT UNSIGNED
    ,BIGINT_UNSIGNED_test	BIGINT UNSIGNED
    ,BIGINT_test	BIGINT
    ,FLOAT_test	FLOAT
    ,DOUBLE_test	DOUBLE
    ,DOUBLE_PRECISION_test	DOUBLE PRECISION
    ,NUMERIC_test	NUMERIC(15,3)
    ,DECIMAL_test	DECIMAL(15,3)
    ,BOOLEAN_test	BOOLEAN
    ,TINYINT1_test	TINYINT(1)
    ,DATE_test	DATE
    ,TIME_test	TIME(3)
    ,DATETIME_test	DATETIME(3)
    ,CHAR_test	CHAR(250)
    ,VARCHAR_test	VARCHAR(250)
    ,TEXT_test	TEXT
    ,BINARY_test	BINARY
    ,VARBINARY_test	VARBINARY(255)
    ,BLOB_test	BLOB
    ,primary key (BIGINT_test)
);



INSERT INTO all_flink_type (
    TINYINT_test,
    SMALLINT_test,
    TINYINT_UNSIGNED_test,
    INT_test,
    MEDIUMINT_test,
    SMALLINT_UNSIGNED_test,
    INT_UNSIGNED_test,
    BIGINT_UNSIGNED_test,
    BIGINT_test,
    FLOAT_test,
    DOUBLE_test,
    DOUBLE_PRECISION_test,
    NUMERIC_test,
    DECIMAL_test,
    BOOLEAN_test,
    TINYINT1_test,
    DATE_test,
    TIME_test,
    DATETIME_test,
    CHAR_test,
    VARCHAR_test,
    TEXT_test,
    BINARY_test,
    VARBINARY_test,
    BLOB_test
) VALUES (
             1,           -- TINYINT
             2,           -- SMALLINT
             3,           -- TINYINT UNSIGNED
             4,           -- INT
             5,           -- MEDIUMINT
             6,           -- SMALLINT UNSIGNED
             7,           -- INT UNSIGNED
             8,           -- BIGINT UNSIGNED
             1,           -- BIGINT
             10.5,        -- FLOAT
             11.56,       -- DOUBLE
             12.78,       -- DOUBLE PRECISION
             13.123,      -- NUMERIC(15,3)
             14.123,      -- DECIMAL(15,3)
             TRUE,        -- BOOLEAN
             1,           -- TINYINT(1)
             '2023-10-23', -- DATE
             '14:30:45.123', -- TIME(3)
             '2023-10-23 14:30:45.123', -- DATETIME(3)
             'Some text',  -- CHAR(250)
             'More text',  -- VARCHAR(250)
             'Text data',  -- TEXT
             'B', -- BINARY (假设是字符串形式表示二进制数据)
             CAST('VarBinary data' AS BINARY), -- VARBINARY(255)
             'Blob data'   -- BLOB
 );

select  * from all_flink_type