例子 - id

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

1 < id < 5

select id FROM test_isolation.user where id > 1 and id < 5;

1 <= id < 5

select id FROM test_isolation.user where id >= 1 and id < 5;

1 < id <= 5

select id FROM test_isolation.user where id > 1 and id <= 5;

1 <= id <= 5

select id FROM test_isolation.user where id >= 1 and id <= 5;

1 < id

select id FROM test_isolation.user where id > 1;

1 <= id

select id FROM test_isolation.user where id >= 1;

id < 5

select id FROM test_isolation.user where id < 5;

id <= 5

select id FROM test_isolation.user where id <= 5;

例子 - firstname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age

• idx_aliasname_unique

  select firstname FROM test_isolation.user where firstname > 'fa' and firstname < 'fe';

  
  

• 
  

  select firstname FROM test_isolation.user where firstname >= 'fa' and firstname <= 'fe';

  
  

例子 - middlename

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select middlename FROM test_isolation.user where middlename > 'ma' and middlename < 'me';

  
  

select middlename FROM test_isolation.user where middlename >= 'ma' and middlename <= 'me';

例子 - lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select lastname FROM test_isolation.user where lastname > 'la' and lastname < 'le';

  
  

select lastname FROM test_isolation.user where lastname >= 'la' and lastname <= 'le';

例子 - age

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age

• idx_aliasname_unique

  select age FROM test_isolation.user where age > 10 and age < 50;

  
  

  select age FROM test_isolation.user where age >= 10 and age <= 50;

  
  

  例子 - aliasname

• idx_firstname

• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select aliasname FROM test_isolation.user where aliasname > 'aa' and aliasname < 'ae';

  
  

select aliasname FROM test_isolation.user where aliasname >= 'aa' and aliasname <= 'ae';

例子 - remark

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select lastname FROM test_isolation.user where remark > 'ra' and remark < 're';

  
  

select remark FROM test_isolation.user where remark >= 'ra' and remark <= 're';

例子 - firstname,middlename

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,middlename FROM test_isolation.user where firstname > 'fa'and middlename > 'ma';

  
  

select firstname,middlename FROM test_isolation.user where firstname >= 'fa'and middlename >= 'ma';

例子 - firstname,middlename,lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,middlename,lastname FROM test_isolation.user where firstname > 'fa'and middlename > 'ma' and lastname > 'la';

  
  

select firstname,middlename,lastname FROM test_isolation.user where firstname >= 'fa'and middlename >= 'ma' and lastname >= 'la';

例子 - firstname,middlename,lastname,age

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,middlename,lastname,age FROM test_isolation.user where firstname = 'fa' and middlename = 'ma' and lastname = 'la' and age > 10 and age < 50;

  
  

select firstname,middlename,lastname,age FROM test_isolation.user where firstname = 'fa' and middlename = 'ma' and lastname = 'la' and age >= 10 and age <= 50;

例子 - firstname,middlename,lastname,age,remark

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,middlename,lastname,age,remark FROM test_isolation.user where firstname = 'fa'and middlename = 'ma' and lastname = 'la' and age = 10 and remark = 'ra';

  
  

例子 - firstname,lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,lastname FROM test_isolation.user where firstname > 'fa' and lastname > 'la';

  
  

select firstname,lastname FROM test_isolation.user where firstname >= 'fa' and lastname >= 'la';

select firstname,lastname FROM test_isolation.user where firstname > 'fa' and lastname >= 'la';

select firstname,lastname FROM test_isolation.user where firstname >= 'fa' and lastname > 'la';

例子 - firstname,remark

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,remark FROM test_isolation.user where firstname > 'fa' and remark > 'ra';

  
  

select firstname,remark FROM test_isolation.user where firstname >= 'fa' and remark >='ra';

例子 - middlename,lastname

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select middlename,lastname FROM test_isolation.user where middlename > 'ma' and lastname > 'la';

  
  

select middlename,lastname FROM test_isolation.user where middlename >= 'ma' and lastname >= 'la';

例子 - firstname,age

• idx_firstname
• idx_firstname_middlename
• idx_firstname_middlename_lastname
• idx_age
• idx_aliasname_unique

  select firstname,age FROM test_isolation.user where firstname > 'fa' and age > 10;

  
  

select firstname,age FROM test_isolation.user where firstname > 'fa' and age < 10;

select firstname,age FROM test_isolation.user where firstname > 'fa' and age > 10 and age < 50;

select firstname,age FROM test_isolation.user where firstname > 'fa' and age >= 10 and age <= 50;