无法执行SQL语句新建表,看了一下内存占用,如下。

29796

以下为错误信息!

1017 - Can't find file: 'pd_credit_log201406' (errno: 2)
CREATE TABLE pd_credit_log201406 (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT ,
file_id bigint(20) UNSIGNED NOT NULL DEFAULT 0 ,
credit float UNSIGNED NOT NULL DEFAULT 0 ,
action varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
in_time int(10) UNSIGNED NOT NULL DEFAULT 0 ,
ip varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
userid int(10) UNSIGNED NOT NULL DEFAULT 0 ,
ref varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (id),
INDEX intime (in_time) USING BTREE ,
INDEX userid (userid) USING BTREE ,
INDEX action (action) USING BTREE ,
INDEX file_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