2个资料表..A表结构..
CREATE TABLE `A` (
`account_name` varchar(13) NOT NULL DEFAULT '0',
`objid` int(11) unsigned NOT NULL DEFAULT '0',
`char_name` varchar(45) NOT NULL DEFAULT '',
`level` int(11) unsigned NOT NULL DEFAULT '0',
`HighLevel` int(11) unsigned NOT NULL DEFAULT '0',
`Exp` int(10) unsigned NOT NULL DEFAULT '0',
`MaxHp` int(10) unsigned NOT NULL DEFAULT '0',
`CurHp` int(10) unsigned NOT NULL DEFAULT '0',
`MaxMp` int(10) NOT NULL DEFAULT '0',
`CurMp` int(10) NOT NULL DEFAULT '0',
`Ac` int(10) NOT NULL DEFAULT '0',
`Str` int(3) NOT NULL DEFAULT '0',
`Con` int(3) NOT NULL DEFAULT '0',
`Dex` int(3) NOT NULL DEFAULT '0',
`Cha` int(3) NOT NULL DEFAULT '0',
`Intel` int(3) NOT NULL DEFAULT '0',
`Wis` int(3) NOT NULL DEFAULT '0',
`Status` int(10) unsigned NOT NULL DEFAULT '0',
`Class` int(10) unsigned NOT NULL DEFAULT '0',
`Sex` int(10) unsigned NOT NULL DEFAULT '0',
`Type` int(10) unsigned NOT NULL DEFAULT '0',
`Shenxian` int(10) NOT NULL,
`Mingren` int(10) NOT NULL,
`da` int(10) NOT NULL,
`xiao` int(10) NOT NULL,
`zhong` int(10) NOT NULL,
`yi` int(10) NOT NULL,
`er` int(10) NOT NULL,
`san` int(10) NOT NULL,
`si` int(10) NOT NULL,
`wu` int(10) NOT NULL,
`liu` int(10) NOT NULL,
`yuanbao` int(10) NOT NULL,
`zongyb` int(10) NOT NULL,
`zzcishu` int(10) NOT NULL,
`sbjy` int(10) NOT NULL,
`jbgj` int(10) NOT NULL,
`huifei` int(10) NOT NULL,
`Heading` int(10) unsigned NOT NULL DEFAULT '0',
`LocX` int(11) unsigned NOT NULL DEFAULT '0',
`LocY` int(11) unsigned NOT NULL DEFAULT '0',
`MapID` int(10) unsigned NOT NULL DEFAULT '0',
`Food` int(10) unsigned NOT NULL DEFAULT '0',
`Lawful` int(10) NOT NULL DEFAULT '0',
`Title` varchar(35) NOT NULL DEFAULT '',
`ClanID` int(10) unsigned NOT NULL DEFAULT '0',
`Clanname` varchar(45) NOT NULL DEFAULT '',
`ClanRank` int(3) NOT NULL DEFAULT '0',
`BonusStatus` int(10) NOT NULL DEFAULT '0',
`ElixirStatus` int(10) NOT NULL DEFAULT '0',
`ElfAttr` int(10) NOT NULL DEFAULT '0',
`PKcount` int(10) NOT NULL DEFAULT '0',
`ExpRes` int(10) NOT NULL DEFAULT '0',
`PartnerID` int(10) NOT NULL DEFAULT '0',
`AccessLevel` int(10) unsigned NOT NULL DEFAULT '0',
`OnlineStatus` int(10) unsigned NOT NULL DEFAULT '0',
`HomeTownID` int(10) NOT NULL DEFAULT '0',
`Contribution` int(10) NOT NULL DEFAULT '0',
`Pay` int(10) NOT NULL DEFAULT '0',
`HellTime` int(10) unsigned NOT NULL DEFAULT '0',
`Banned` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Karma` int(10) NOT NULL DEFAULT '0',
`LastPk` datetime DEFAULT NULL,
`DeleteTime` datetime DEFAULT NULL,
PRIMARY KEY (`objid`),
KEY `key_id` (`account_name`,`char_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;B表结构..
CREATE TABLE `B` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`level` int(10) NOT NULL,
`name` varchar(45) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MyISAM free: 10240 kB; MyISAM free: 10240 kB';先将A表的level栏位按照降序排列...并查询出前20位的name值...
将level 和 name的值插入B表!!!
CREATE TABLE `A` (
`account_name` varchar(13) NOT NULL DEFAULT '0',
`objid` int(11) unsigned NOT NULL DEFAULT '0',
`char_name` varchar(45) NOT NULL DEFAULT '',
`level` int(11) unsigned NOT NULL DEFAULT '0',
`HighLevel` int(11) unsigned NOT NULL DEFAULT '0',
`Exp` int(10) unsigned NOT NULL DEFAULT '0',
`MaxHp` int(10) unsigned NOT NULL DEFAULT '0',
`CurHp` int(10) unsigned NOT NULL DEFAULT '0',
`MaxMp` int(10) NOT NULL DEFAULT '0',
`CurMp` int(10) NOT NULL DEFAULT '0',
`Ac` int(10) NOT NULL DEFAULT '0',
`Str` int(3) NOT NULL DEFAULT '0',
`Con` int(3) NOT NULL DEFAULT '0',
`Dex` int(3) NOT NULL DEFAULT '0',
`Cha` int(3) NOT NULL DEFAULT '0',
`Intel` int(3) NOT NULL DEFAULT '0',
`Wis` int(3) NOT NULL DEFAULT '0',
`Status` int(10) unsigned NOT NULL DEFAULT '0',
`Class` int(10) unsigned NOT NULL DEFAULT '0',
`Sex` int(10) unsigned NOT NULL DEFAULT '0',
`Type` int(10) unsigned NOT NULL DEFAULT '0',
`Shenxian` int(10) NOT NULL,
`Mingren` int(10) NOT NULL,
`da` int(10) NOT NULL,
`xiao` int(10) NOT NULL,
`zhong` int(10) NOT NULL,
`yi` int(10) NOT NULL,
`er` int(10) NOT NULL,
`san` int(10) NOT NULL,
`si` int(10) NOT NULL,
`wu` int(10) NOT NULL,
`liu` int(10) NOT NULL,
`yuanbao` int(10) NOT NULL,
`zongyb` int(10) NOT NULL,
`zzcishu` int(10) NOT NULL,
`sbjy` int(10) NOT NULL,
`jbgj` int(10) NOT NULL,
`huifei` int(10) NOT NULL,
`Heading` int(10) unsigned NOT NULL DEFAULT '0',
`LocX` int(11) unsigned NOT NULL DEFAULT '0',
`LocY` int(11) unsigned NOT NULL DEFAULT '0',
`MapID` int(10) unsigned NOT NULL DEFAULT '0',
`Food` int(10) unsigned NOT NULL DEFAULT '0',
`Lawful` int(10) NOT NULL DEFAULT '0',
`Title` varchar(35) NOT NULL DEFAULT '',
`ClanID` int(10) unsigned NOT NULL DEFAULT '0',
`Clanname` varchar(45) NOT NULL DEFAULT '',
`ClanRank` int(3) NOT NULL DEFAULT '0',
`BonusStatus` int(10) NOT NULL DEFAULT '0',
`ElixirStatus` int(10) NOT NULL DEFAULT '0',
`ElfAttr` int(10) NOT NULL DEFAULT '0',
`PKcount` int(10) NOT NULL DEFAULT '0',
`ExpRes` int(10) NOT NULL DEFAULT '0',
`PartnerID` int(10) NOT NULL DEFAULT '0',
`AccessLevel` int(10) unsigned NOT NULL DEFAULT '0',
`OnlineStatus` int(10) unsigned NOT NULL DEFAULT '0',
`HomeTownID` int(10) NOT NULL DEFAULT '0',
`Contribution` int(10) NOT NULL DEFAULT '0',
`Pay` int(10) NOT NULL DEFAULT '0',
`HellTime` int(10) unsigned NOT NULL DEFAULT '0',
`Banned` tinyint(1) unsigned NOT NULL DEFAULT '0',
`Karma` int(10) NOT NULL DEFAULT '0',
`LastPk` datetime DEFAULT NULL,
`DeleteTime` datetime DEFAULT NULL,
PRIMARY KEY (`objid`),
KEY `key_id` (`account_name`,`char_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;B表结构..
CREATE TABLE `B` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`level` int(10) NOT NULL,
`name` varchar(45) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MyISAM free: 10240 kB; MyISAM free: 10240 kB';先将A表的level栏位按照降序排列...并查询出前20位的name值...
将level 和 name的值插入B表!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货