mysql指定符号化セット

39288 ワード

DROP TABLE app_info
CREATE TABLE  `app_info`
(
       `app_id`          VARCHAR(20) NOT NULL COMMENT '  ID',
       `app_name`        VARCHAR(100) NOT NULL COMMENT '    ',
       `source_market`   VARCHAR(50) COMMENT '      ',
       `version`         VARCHAR(10) COMMENT '   ',
       `update_time`     INT DEFAULT 0 COMMENT '    ',
       `donwload_times`  INT DEFAULT 0 COMMENT '    ',
       `evaluation_index` VARCHAR(20) COMMENT '      ',
       `app_down_url`    VARCHAR(200) COMMENT '      ',
       `app_org`         VARCHAR(100) COMMENT '      ',
       `app_market_url`  VARCHAR(200) COMMENT '      ',
       `org_tel`         VARCHAR(20) COMMENT '    ',
       `org_mail`        VARCHAR(50) COMMENT '    ',
       `app_devp`        VARCHAR(50) COMMENT '     ',
       `devp_url`        VARCHAR(200) COMMENT '     ',
       `devp_tel`        VARCHAR(20) COMMENT '     ',
       `devp_mail`       VARCHAR(50) COMMENT '     ',
       `is_illegal`      BIT COMMENT '    ',
       `illegal_reason`  VARCHAR(200) COMMENT '    '
) ENGINE=INNODB AUTO_INCREMENT=1695497 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 
転載先:https://www.cnblogs.com/duanjt/p/8872290.html
DROP TABLE app_info
CREATE TABLE  `app_info`
(
       `app_id`          VARCHAR(20) NOT NULL COMMENT '  ID',
       `app_name`        VARCHAR(100) NOT NULL COMMENT '    ',
       `source_market`   VARCHAR(50) COMMENT '      ',
       `version`         VARCHAR(10) COMMENT '   ',
       `update_time`     INT DEFAULT 0 COMMENT '    ',
       `donwload_times`  INT DEFAULT 0 COMMENT '    ',
       `evaluation_index` VARCHAR(20) COMMENT '      ',
       `app_down_url`    VARCHAR(200) COMMENT '      ',
       `app_org`         VARCHAR(100) COMMENT '      ',
       `app_market_url`  VARCHAR(200) COMMENT '      ',
       `org_tel`         VARCHAR(20) COMMENT '    ',
       `org_mail`        VARCHAR(50) COMMENT '    ',
       `app_devp`        VARCHAR(50) COMMENT '     ',
       `devp_url`        VARCHAR(200) COMMENT '     ',
       `devp_tel`        VARCHAR(20) COMMENT '     ',
       `devp_mail`       VARCHAR(50) COMMENT '     ',
       `is_illegal`      BIT COMMENT '    ',
       `illegal_reason`  VARCHAR(200) COMMENT '    '
) ENGINE=INNODB AUTO_INCREMENT=1695497 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;