-1
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1
  • D、select * from users where b = 2 and c = 1
回答后才能看到答案和解析
5年前上传
32个回答
  • B、select * from users where b = 2 and a = 1

test

5年前回答
  • B、select * from users where b = 2 and a = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

lmz李 24
4年前回答
  • A、select * from users where a = 1 and b = 2
  • D、select * from users where b = 2 and c = 1

tteee 270
4年前回答
  • A、select * from users where a = 1 and b = 2
  • D、select * from users where b = 2 and c = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1
  • D、select * from users where b = 2 and c = 1

wufei 72
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1

最左侧匹配原则,

  1. a,b,c
  2. a,b
  3. a,c 只用到a 按顺序,不能有运算,函数,表达式,且like只能是前缀匹配,order 多字段排序,需要升降级一致

aftersun 3313
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1
  • D、select * from users where b = 2 and c = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1
  • D、select * from users where b = 2 and c = 1

ithuan 1
4年前回答
  • A、select * from users where a = 1 and b = 2
  • C、select * from users where a = 2 and c = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

最左前缀匹配

Bailiff 12
4年前回答
  • A、select * from users where a = 1 and b = 2
  • D、select * from users where b = 2 and c = 1

4年前回答
  • A、select * from users where a = 1 and b = 2

4年前回答
  • A、select * from users where a = 1 and b = 2
  • C、select * from users where a = 2 and c = 1

fed126 34
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

lzq603 1
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1

cffirm 7
4年前回答
  • A、select * from users where a = 1 and b = 2
  • C、select * from users where a = 2 and c = 1

Adamlet 32
4年前回答
  • A、select * from users where a = 1 and b = 2
  • D、select * from users where b = 2 and c = 1

yuye 902
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1

yinshi 8
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

蛋蛋CC 1353
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1

lampyou 30
4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • D、select * from users where b = 2 and c = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1

4年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1
  • C、select * from users where a = 2 and c = 1

3年前回答
  • A、select * from users where a = 1 and b = 2
  • D、select * from users where b = 2 and c = 1

3年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

mihx 68
3年前回答
  • A、select * from users where a = 1 and b = 2
  • B、select * from users where b = 2 and a = 1

dwaff 1
1年前回答
我的回答