mysql where多个索引吗_一个查询的where列如果多于3个,是不是不走索引更好!有例子,希望大家积极讨论一下。...

select accountmod0_.account_id as account1_0_, accountmod0_.account_type_id as account2_0_, accountmod0_.hotel_id as hotel3_0_, accountmod0_.hotelgroup_id as hotelgroup4_0_, accountmod0_.register_id as register5_0_, accountmod0_.guest_id as guest6_0_, accountmod0_.group_id as group7_0_, accountmod0_.company_id as company8_0_, accountmod0_.money as money0_, accountmod0_.payment_method_id as payment10_0_, accountmod0_.is_reversed as is11_0_, accountmod0_.is_balanced as is12_0_, accountmod0_.from_account_id as from13_0_, accountmod0_.to_account_id as to14_0_, accountmod0_.cash_bill_no as cash15_0_, accountmod0_.shift_id as shift16_0_, accountmod0_.account_date as account17_0_, accountmod0_.created_at as created18_0_, accountmod0_.note as note0_, accountmod0_.hotel_operator_id as hotel20_0_, accountmod0_.pos_site_id as pos21_0_, accountmod0_.room_order_id as room22_0_, accountmod0_.close_date as close23_0_, accountmod0_.close_shift_id as close24_0_, accountmod0_.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值