为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:
【CPU】:
【问题描述】*:mysql执行成功
CREATE TABLE test6969 (
ID VARCHAR ( 128 ) PRIMARY KEY NOT NULL,
TASKCODE VARCHAR ( 80 ),
STATE VARCHAR ( 40 ),
PLACECODE VARCHAR ( 128 ),
SOURCE VARCHAR ( 40 ),
WTTYPE VARCHAR ( 40 ),
GRADE VARCHAR ( 8 ),
TYPE1_ID VARCHAR ( 128 ),
TYPE1_NAME VARCHAR ( 200 ),
TYPE2_ID VARCHAR ( 128 ),
TYPE2_NAME VARCHAR ( 200 ),
TYPE3_ID VARCHAR ( 128 ),
TYPE3_NAME VARCHAR ( 200 ),
CITYCODE VARCHAR ( 40 ),
TOWNCODE VARCHAR ( 40 ),
STREET_ID VARCHAR ( 128 ),
COUNTRY_ID VARCHAR ( 128 ),
GRID_ID VARCHAR ( 128 ),
REPORTER_CALLPHONE VARCHAR ( 80 ),
PATROLER_ID VARCHAR ( 128 ),
REPORTER_ID VARCHAR ( 128 ),
OPERATOR_ID VARCHAR ( 128 ),
ADDRESS VARCHAR ( 400 ),
POINTX VARCHAR ( 80 ),
POINTY VARCHAR ( 80 ),
EVENTDESC text,
CREATETIME BIGINT,
SIMPLE VARCHAR ( 40 ),
CURRENT_ID VARCHAR ( 128 ),
CURRENTDEPT_ID VARCHAR ( 128 ),
SIGN VARCHAR ( 200 ),
DEALRESULT text,
DEALTIME BIGINT,
PRETASKCODE VARCHAR ( 800 ),
DEADTIME BIGINT,
LOCKEVENT VARCHAR ( 200 ),
IFDEAL VARCHAR ( 200 ),
IFCONTACT VARCHAR ( 200 ),
GRADE_DEAD_TIME BIGINT,
GMT_CREATE BIGINT,
INVOLVED_NUMBER VARCHAR ( 200 ),
INVOLVED_MONEY VARCHAR ( 200 ),
SITE_ID VARCHAR ( 200 ),
SOURCE_JFTJ TINYINT ( 3 ),
IF_NOTICE_LEADER TINYINT ( 3 ) NOT NULL,
UPDATETIME TIMESTAMP,
PARENT_ID VARCHAR ( 200 ),
FORMTYPE VARCHAR ( 200 ),
CHANNEL VARCHAR ( 200 ),
IFCHECK VARCHAR ( 200 ),
IFORDER VARCHAR ( 200 )
);
应该是TINYINT 类型的问题,把后面括号里面的精度去掉。
CREATE TABLE test6969 (
ID VARCHAR ( 128 ) PRIMARY KEY NOT NULL,
TASKCODE VARCHAR ( 80 ),
STATE VARCHAR ( 40 ),
PLACECODE VARCHAR ( 128 ),
SOURCE VARCHAR ( 40 ),
WTTYPE VARCHAR ( 40 ),
GRADE VARCHAR ( 8 ),
TYPE1_ID VARCHAR ( 128 ),
TYPE1_NAME VARCHAR ( 200 ),
TYPE2_ID VARCHAR ( 128 ),
TYPE2_NAME VARCHAR ( 200 ),
TYPE3_ID VARCHAR ( 128 ),
TYPE3_NAME VARCHAR ( 200 ),
CITYCODE VARCHAR ( 40 ),
TOWNCODE VARCHAR ( 40 ),
STREET_ID VARCHAR ( 128 ),
COUNTRY_ID VARCHAR ( 128 ),
GRID_ID VARCHAR ( 128 ),
REPORTER_CALLPHONE VARCHAR ( 80 ),
PATROLER_ID VARCHAR ( 128 ),
REPORTER_ID VARCHAR ( 128 ),
OPERATOR_ID VARCHAR ( 128 ),
ADDRESS VARCHAR ( 400 ),
POINTX VARCHAR ( 80 ),
POINTY VARCHAR ( 80 ),
EVENTDESC text,
CREATETIME BIGINT,
SIMPLE VARCHAR ( 40 ),
CURRENT_ID VARCHAR ( 128 ),
CURRENTDEPT_ID VARCHAR ( 128 ),
SIGN VARCHAR ( 200 ),
DEALRESULT text,
DEALTIME BIGINT,
PRETASKCODE VARCHAR ( 800 ),
DEADTIME BIGINT,
LOCKEVENT VARCHAR ( 200 ),
IFDEAL VARCHAR ( 200 ),
IFCONTACT VARCHAR ( 200 ),
GRADE_DEAD_TIME BIGINT,
GMT_CREATE BIGINT,
INVOLVED_NUMBER VARCHAR ( 200 ),
INVOLVED_MONEY VARCHAR ( 200 ),
SITE_ID VARCHAR ( 200 ),
SOURCE_JFTJ TINYINT ,
IF_NOTICE_LEADER TINYINT NOT NULL,
UPDATETIME TIMESTAMP,
PARENT_ID VARCHAR ( 200 ),
FORMTYPE VARCHAR ( 200 ),
CHANNEL VARCHAR ( 200 ),
IFCHECK VARCHAR ( 200 ),
IFORDER VARCHAR ( 200 )
);