mysql 每种类型取一条

CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    tinyint_col TINYINT,
    smallint_col SMALLINT,
    mediumint_col MEDIUMINT,
    int_col INT,
    bigint_col BIGINT,
    float_col FLOAT,
    double_col DOUBLE,
    date_col DATE,
    time_col TIME,
    datetime_col DATETIME,
    timestamp_col TIMESTAMP,
    char_col CHAR(10),
    varchar_col VARCHAR(255),
    text_col TEXT,
    binary_col BINARY(10),
    varbinary_col VARBINARY(255),
    blob_col BLOB
);

SELECT 
    (SELECT tinyint_col FROM example_table LIMIT 1) AS tinyint_example,
    (SELECT smallint_col FROM example_table LIMIT 1) AS smallint_example,
    (SELECT mediumint_col FROM example_table LIMIT 1) AS mediumint_example,
    (SELECT int_col FROM example_table LIMIT 1) AS int_example,
    (SELECT bigint_col FROM example_table LIMIT 1) AS bigint_example,
    (SELECT float_col FROM example_table LIMIT 1) AS float_example,
    (SELECT double_col FROM example_table LIMIT 1) AS double_example,
    (SELECT date_col FROM example_table LIMIT 1) AS date_example,
    (SELECT time_col FROM example_table LIMIT 1) AS time_example,
    (SELECT datetime_col FROM example_table LIMIT 1) AS datetime_example,
    (SELECT timestamp_col FROM example_table LIMIT 1) AS timestamp_example,
    (SELECT char_col FROM example_table LIMIT 1) AS char_example,
    (SELECT varchar_col FROM example_table LIMIT 1) AS varchar_example,
    (SELECT text_col FROM example_table LIMIT 1) AS text_example,
    (SELECT binary_col FROM example_table LIMIT 1) AS binary_example,
    (SELECT varbinary_col FROM example_table LIMIT 1) AS varbinary_example,
    (SELECT blob_col FROM example_table LIMIT 1) AS blob_example;