创建索引 [英] Create index
问题描述
我有一个Mysql查询我想创建一个索引 在下面写入查询 -
* /
$ sql =" select count(opportunity_code)as opc,month(created)as as mon来自tbl_oppourtunities,其中abs(DATEDIFF(date(now()),创建))< = 730和year(created)= year(now()) - 1" ;;
/ *
所以请尽快回复我。
谢谢
Jatashankar patel
< span style ="color:#333333">感谢您的发布。
我建议您在其中一个MSDN论坛中发布您的问题:
SQL服务器开发人员中心
>
SQL Server论坛 > Transact-SQL
位于:
http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads
您可以在此论坛中找到有用的主题。
希望这会有所帮助。
祝你有愉快的一天。
Pan Zhang
客户支持
EPX服务工程支持团队
跨度>
Hi,
i have one Mysql query i want to create an index on below write query--
*/
$sql="select count(opportunity_code) as opc, month(created) as mon from tbl_oppourtunities where abs(DATEDIFF(date(now()),created)) <= 730 and year(created)=year(now())-1";
/*
So please reply me asap.
Thanks
Jatashankar patel
Hi,
Thank you for your post.
I'd like to suggest posting your question in one of the MSDN Forums:
SQL Server Developer Center > SQL Server Forums > Transact-SQL
Located at:
http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads
You can find useful topics within this forum.
Hope this would be helpful.
Have a nice day.
Pan Zhang
Customer Support
EPX Service Engineering Support Team
这篇关于创建索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!