- wmfy8082014-06-20论坛元老4703
无法执行SQL语句新建表,看了一下内存占用,如下。
29796
以下为错误信息!
1017 - Can't find file: 'pd_credit_log201406' (errno: 2)
CREATE TABLEpd_credit_log201406(idbigint(20) UNSIGNED NOT NULL AUTO_INCREMENT ,file_idbigint(20) UNSIGNED NOT NULL DEFAULT 0 ,creditfloat UNSIGNED NOT NULL DEFAULT 0 ,actionvarchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,in_timeint(10) UNSIGNED NOT NULL DEFAULT 0 ,ipvarchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,useridint(10) UNSIGNED NOT NULL DEFAULT 0 ,refvarchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (id),
INDEXintime(in_time) USING BTREE ,
INDEXuserid(userid) USING BTREE ,
INDEXaction(action) USING BTREE ,
INDEXfile_id(file_id) USING BTREE
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;
Finished - Unsuccessfully