Error:Table 'ucenter.uc_pms' doesn't exist解决方法

admin

DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
* R% P7 d- A/ j# U# MySQL 返回的查询结果为空(即零行)。
CREATE TABLE uc_pms(
+ B& {; d7 r5 f4 R2 r! Fpmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
1 o4 b/ Z' S; ]msgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
msgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
msgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
folder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
new TINYINT( 1 ) NOT NULL DEFAULT '0',
6 V; j6 o: V% }& osubject VARCHAR( 75 ) NOT NULL DEFAULT '',
) k: p  R- {! c5 ?dateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
message TEXT NOT NULL ,
delstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
3 Y/ R+ ]' e' S/ S9 T6 C: T' Q% lrelated INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( pmid ) ,
KEY msgtoid( msgtoid, folder, dateline ) ,
KEY msgfromid( msgfromid, folder, dateline ) ,
KEY RELATED( related ) ,
KEY getnum( msgtoid, folder, delstatus )
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。
2 y7 ]! X" m  ~% W. }
! J- N) `9 q- o( u- S  E