先看报错信息:
[09:27:17] Failed Exec strSQL : Create Table test.SmRegister(SmDatasetID INT NOT NULL primary key,SmDatasetName VarChar(64) NOT NULL,SmTableName VarChar(64) NOT NULL,SmIndexTableName VarChar(64) NOT NULL,SmSubTableName VarChar(64),SmParentID INT DEFAULT 0 NOT NULL,SmIsSub Char(1),SmDatasetType INT DEFAULT 0 NOT NULL,SmRecordCount INT DEFAULT 0 NOT NULL,SmLeft Double DEFAULT 0 NOT NULL,SmRight Double DEFAULT 0 NOT NULL,SmTop Double DEFAULT 0 NOT NULL,SmBottom Double DEFAULT 0 NOT NULL,SmIndexType Double DEFAULT 1 NOT NULL,SmIndexLevel INT DEFAULT 0 NOT NULL,SmIndexLeft Double DEFAULT 0 NOT NULL,SmIndexRight Double DEFAULT 0 NOT NULL,SmIndexTop Double DEFAULT 0 NOT NULL,SmIndexBottom Double DEFAULT 0 NOT NULL,SmMinZ Double DEFAULT 0 NOT NULL,SmMaxZ Double DEFAULT 0 NOT NULL,SmDtVersion INT DEFAULT 0 NOT NULL,SmOption INT,SmEncType INT DEFAULT 0 NOT NULL,SmDescription VarChar(256),SmExtInfo VarChar(2048),SmToleRanceFuzzy Double DEFAULT 0 NOT NULL,SmToleranceDAngle Double DEFAULT 0 NOT NULL,SmToleranceNodeSnap Double DEFAULT 0 NOT NULL,SmToleranceSmallPolygon Double DEFAULT 0 NOT NULL,SmToleranceGrain Double DEFAULT 0 NOT NULL,SmMaxGeometrySize INT DEFAULT 0 NOT NULL,SmOnceFetchCount INT DEFAULT 4096 NOT NULL,SmOptimizeCount INT DEFAULT 100000 NOT NULL,SmOptimizeRatio Double DEFAULT 0.6 NOT NULL,SmCreateTime TIMESTAMP(6) NOT NULL,SmLastUpdate TIMESTAMP(6),SmCreator VarChar(32) DEFAULT ' ' NOT NULL, SmThumb BLOB,SmProjectInfo LONGBLOB) ENGINE = MyISAM-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL,SmLastUpdate TIMESTAMP(6),SmCreator VarChar(32) DEFAULT ' ' NOT NUL' at line 1
[09:27:17] 创建数据源“127.0.0.1_test”失败。
将本sql 复制到mysql执行,问题可以定位 到
SmCreateTime TIMESTAMP(6) NOT NULL ,
SmLastUpdate TIMESTAMP(6) ,
TIMESTAMP 指定长度后报错,去掉指定长度后,就可以!mysql 版本是 service version :5.5.56 mysql communtiy server<GPL> 该问题谁能该解决一下?