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
解决方案 »
- 求sql ?
- 求助~~ Mysql数据的导入
- disuz数据库查询问题
- mysql如何执行一个批处理文件
- 有用C语言开发mysql数据库的同事吗?问个结果集获取的问题。
- mysql 存储自定义线条!大家各显神通啊!
- 请问windows下mysql中怎么才能找到libmysql.lib这个文件?
- postgres SQL的使用问题
- mysql的远程连接to:webmin(webmin)
- You have an error in your SQL syntax; check the manual that corresponds to your
- 形似SELECT...IN...ORDER BY的语句如何优化
- mysql Error Code: 1146;
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#结帖