我现在在学mysql,想问一下下面语句中的KEY uid (uid)是什么意思,这key的语法在那有说,谢谢
CREATE TABLE cdb_activityapplies (
applyid int(10) unsigned NOT NULL auto_increment,
tid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
message char(200) NOT NULL default '',
verified tinyint(1) NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
payment mediumint(8) NOT NULL default '0',
PRIMARY KEY (applyid),
KEY uid (uid),
KEY tid (tid),
KEY dateline (tid,dateline)
) TYPE=MyISAM AUTO_INCREMENT=1;
CREATE TABLE cdb_activityapplies (
applyid int(10) unsigned NOT NULL auto_increment,
tid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
message char(200) NOT NULL default '',
verified tinyint(1) NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
payment mediumint(8) NOT NULL default '0',
PRIMARY KEY (applyid),
KEY uid (uid),
KEY tid (tid),
KEY dateline (tid,dateline)
) TYPE=MyISAM AUTO_INCREMENT=1;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货