show create table 的结果
| t_yx_new_present_stat | CREATE TABLE `t_yx_new_present_stat` (
`MPRuleID` varchar(128) NOT NULL default '',
`GoodsID` varchar(64) NOT NULL default '',
`DayPresentNum` int(12) default NULL,
`GoodsName` varchar(64) default NULL,
`GoodsType` int(11) default NULL,
`ServiceCode` varchar(32) default NULL,
`GoodsNumber` int(11) default NULL,
`SaleNumber` int(11) default NULL,
`StateTime` date NOT NULL default '0000-00-00',
`name` varchar(128) default NULL,
`bu` varchar(128) default NULL,
`department` varchar(128) default NULL,
`type` varchar(128) default NULL,
`product` varchar(128) default NULL,
`mainMPRuleID` varchar(128) default NULL,
PRIMARY KEY (`MPRuleID`,`GoodsID`,`StateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | sql语句
select GoodsID,GoodsName,date_format(statetime, '%Y-%m-%d') StateTime,MPRuleID,Name as ActivityName ,GoodsNumber,sum(DayPresentNum) DayPresentNum from t_yx_new_present_stat where StateTime between '2012-04-23' and '2012-05-23' and GoodsID = '20120522191353859' group by GoodsID, GoodsName,StateTime,MPRuleID,Name order by GoodsID, GoodsName,StateTime ASC,MPRuleID;当前数据库空负载的情况下执行时间为2.53 sec
| t_yx_new_present_stat | CREATE TABLE `t_yx_new_present_stat` (
`MPRuleID` varchar(128) NOT NULL default '',
`GoodsID` varchar(64) NOT NULL default '',
`DayPresentNum` int(12) default NULL,
`GoodsName` varchar(64) default NULL,
`GoodsType` int(11) default NULL,
`ServiceCode` varchar(32) default NULL,
`GoodsNumber` int(11) default NULL,
`SaleNumber` int(11) default NULL,
`StateTime` date NOT NULL default '0000-00-00',
`name` varchar(128) default NULL,
`bu` varchar(128) default NULL,
`department` varchar(128) default NULL,
`type` varchar(128) default NULL,
`product` varchar(128) default NULL,
`mainMPRuleID` varchar(128) default NULL,
PRIMARY KEY (`MPRuleID`,`GoodsID`,`StateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | sql语句
select GoodsID,GoodsName,date_format(statetime, '%Y-%m-%d') StateTime,MPRuleID,Name as ActivityName ,GoodsNumber,sum(DayPresentNum) DayPresentNum from t_yx_new_present_stat where StateTime between '2012-04-23' and '2012-05-23' and GoodsID = '20120522191353859' group by GoodsID, GoodsName,StateTime,MPRuleID,Name order by GoodsID, GoodsName,StateTime ASC,MPRuleID;当前数据库空负载的情况下执行时间为2.53 sec
create index xx1 on t_yx_new_present_stat (GoodsID,GoodsName);
'截至2012-05-28 17:25:27 用户结帖率0.00% 当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖