MySQL interval()函数

by · 2018-10-20

INTERVAL(N,N1,N2,N3,……….)

INTERVAL()函数进行比较列表(N1，N2，N3等等)中的N值。该函数如果N<N1返回0，如果N<N2返回1，如果N<N3返回2 等等。如果N为NULL，它将返回-1。列表值必须是N1<N2<N3的形式才能正常工作。下面的代码是显示 INTERVAL()函数如何工作的一个简单的例子：

mysql>SELECT INTERVAL(6,1,2,3,4,5,6,7,8,9,10);
+---------------------------------------------------------+
| INTERVAL(6,1,2,3,4,5,6,7,8,9,10)                        |
+---------------------------------------------------------+
| 6                                                       |
+---------------------------------------------------------+
1 row in set (0.00 sec)

请记住，6是从零开始的索引，列表第一个值的值大于N. 在我们的例子中，7是错误的值，它是位于第六索引插槽。

相关推荐

Tags:

You may also like...

92 Responses

  1. Bopxcb说道：
    2023-12-12 上午5:39

    escitalopram uk generic prozac 20mg order revia online cheap

  2. Vgntno说道：
    2023-12-11 上午6:22

    order lasix 100mg online cheap buy furosemide 100mg online ventolin ca

  3. Dezmkj说道：
    2023-12-10 下午12:31

    buy strattera 25mg quetiapine canada oral sertraline 100mg

  4. Aylmqe说道：
    2023-12-08 下午4:03

    order actigall 150mg sale order cetirizine generic order cetirizine online

  5. Kibgli说道：
    2023-12-06 下午10:40

    zithromax uk buy omnacortil 5mg generic gabapentin medication

  6. Leemru说道：
    2023-12-06 下午4:06

    supplements that help with gerd strong anti nausea pills foods that cause flatulence list

  7. Hzvebo说道：
    2023-12-04 下午10:01

    order prednisone 5mg generic prednisone buy online amoxicillin oral

  8. Xltiax说道：
    2023-12-04 下午6:13

    where to buy pill capsules how long does tadalafil last where to buy volume pills

  9. Zprtfv说道：
    2023-12-03 上午3:29

    purchase phenergan online cheap promethazine 25mg cheap ivermectin 12mg stromectol

  10. Unjuye说道：
    2023-12-03 上午2:45

    dangers of stomach ulcers online blood pressure medication bacterial infection in bladder women

  11. Soyrvh说道：
    2023-12-01 上午10:17

    fungus clear fix reviews bp tablets name and price blood pressure medication with least side effects

  12. Hxbaix说道：
    2023-12-01 上午8:17

    cymbalta 20mg oral duloxetine 40mg sale order provigil 100mg online cheap

  13. Mmqpxf说道：
    2023-11-29 下午8:43

    types of antiviral drugs sign up for herpes medication best diabetes drug without injection

  14. Pqurmr说道：
    2023-11-29 下午5:32

    buy generic periactin order cyproheptadine sale cost nizoral 200mg

  15. Lasmqi说道：
    2023-11-28 下午2:20

    prescription medication for quitting smoking buy stop smoking medication online pharmacy painkillers

  16. Hzffyx说道：
    2023-11-28 上午6:24

    provera price biltricide online hydrochlorothiazide without prescription

  17. Jgvlxz说道：
    2023-11-26 下午7:36

    super strong sleeping pills prescription diet pills online ordering can i buy wegovy without a prescription

  18. Avvmuw说道：
    2023-11-26 上午8:10

    letrozole 2.5 mg oral purchase letrozole pill abilify 30mg ca

  19. Shwtrp说道：
    2023-11-25 上午2:40

    buy uroxatral pills for sale uroxatral 10 mg pills natural substitute for famotidine

  20. Cvyhvz说道：
    2023-11-24 上午5:36

    buy minocin 50mg pill ropinirole 1mg oral purchase requip pills

  21. Qemrxy说道：
    2023-11-23 上午8:35

    prescription medication for adult acne teenage acne treatment for girls buy cheap generic oxcarbazepine

  22. Vimkrw说道：
    2023-11-22 上午8:01

    catapres 0.1 mg over the counter meclizine 25mg us spiriva 9mcg sale

  23. Jrynow说道：
    2023-11-21 下午2:24

    purchase rocaltrol cost fenofibrate 200mg tricor pill

  24. Qxmwwr说道：
    2023-11-20 上午8:04

    order amoxicillin 500mg online buy amoxicillin 500mg for sale buy clarithromycin generic

  25. Ctkgqf说道：
    2023-11-19 下午2:36

    buy a dissertation paper writer free slots games

  26. Ajtcjq说道：
    2023-11-18 上午6:34

    help me with my research paper research paper 9th grade buy cefixime 100mg

  27. Lstfxb说道：
    2023-11-17 下午6:55

    buy aspirin 75mg without prescription gambling website best real casino online

  28. Mohmba说道：
    2023-11-16 上午4:52

    buy cheap lamisil bet and win money online play blackjack online

  29. Htdyml说道：
    2023-11-16 上午2:31

    buy trazodone without a prescription purchase trazodone pills buy generic clindamycin for sale

  30. Mfyjee说道：
    2023-11-13 下午10:37

    buy cefuroxime pill bimatoprost tablet methocarbamol 500mg for sale

  31. Rkqoxg说道：
    2023-11-12 下午1:45

    tadacip 20mg brand oral tadacip buy generic indocin

  32. Mepiej说道：
    2023-11-12 上午3:22

    tamoxifen 20mg without prescription rhinocort canada rhinocort drug

  33. Bxjqii说道：
    2023-11-10 下午1:07

    retin gel sale generic tadalis 10mg order avana 200mg generic

  34. Ctmvrv说道：
    2023-11-10 上午9:28

    cleocin price cost erythromycin 250mg can i buy ed pills over the counter

  35. Ynnhma说道：
    2023-11-08 下午2:30

    flagyl 200mg usa keflex 125mg oral cephalexin 500mg ca

  36. Zgoteb说道：
    2023-11-08 下午2:08

    order lamotrigine 200mg vermox brand buy nemazole

  37. Igjvxx说道：
    2023-11-06 下午7:10

    buy forcan cheap ampicillin 250mg buy baycip

  38. Zzkezp说道：
    2023-11-06 下午2:54

    order generic aurogra sildenafil 50mg price yasmin for sale

  39. Fgysye说道：
    2023-11-04 下午11:36

    spironolactone 25mg usa aldactone 25mg price cheap propecia

  40. Weoapn说道：
    2023-11-04 下午3:33

    term papers writing service order an essay online editing essays

  41. Aqorun说道：
    2023-11-03 上午5:40

    tamsulosin 0.2mg without prescription ondansetron 8mg without prescription zocor 20mg brand

  42. Geibsy说道：
    2023-11-02 上午9:10

    domperidone buy online buy carvedilol online cheap buy tetracycline 500mg for sale

  43. Irreqr说道：
    2023-11-01 上午12:19

    ranitidine 300mg generic buy zantac online order celebrex 200mg pill

  44. Iimfoe说道：
    2023-10-31 上午9:50

    buspirone buy online buy cheap generic ezetimibe order amiodarone for sale

  45. Spvhhe说道：
    2023-10-30 上午1:08

    buy imitrex for sale cheap levofloxacin 500mg buy avodart 0.5mg pill

  46. Zklzfw说道：
    2023-10-29 下午2:40

    zyloprim 300mg over the counter order zyloprim for sale buy generic rosuvastatin over the counter

  47. Bvestb说道：
    2023-10-28 下午12:57

    buy nexium tablets oral topiramate topiramate 100mg uk

  48. Xldgsb说道：
    2023-10-25 下午11:38

    astelin 10 ml sale order acyclovir pills irbesartan order

  49. Rzzwyn说道：
    2023-10-22 上午9:20

    buy cheap generic warfarin order reglan 20mg pill reglan 10mg tablet

  50. Qpkuij说道：
    2023-10-19 上午10:23

    nortriptyline 25mg oral methotrexate 5mg sale acetaminophen price

  51. Kdwtgy说道：
    2023-10-17 上午6:16

    buy inderal 10mg online plavix 150mg cost plavix 150mg oral

  52. Ehxskx说道：
    2023-10-16 上午9:28

    amaryl 1mg over the counter where to buy amaryl without a prescription order generic arcoxia 60mg

  53. Rzjrgd说道：
    2023-10-15 上午12:18

    alendronate us order colchicine furadantin price

  54. Pihtao说道：
    2023-10-12 下午1:43

    lioresal canada toradol pill toradol without prescription

  55. Qsuovk说道：
    2023-10-10 下午9:15

    order claritin loratadine pill priligy 60mg drug

  56. Pouigm说道：
    2023-10-10 下午9:06

    brand ozobax oral toradol ketorolac where to buy

  57. Jtrdcn说道：
    2023-10-08 下午7:12

    order phenytoin 100mg online cheap order dilantin online cheap cheap oxybutynin 2.5mg

  58. Fdgtng说道：
    2023-10-07 下午4:00

    cost aceon buy cheap generic clarinex allegra online buy

  59. Ycjtxm说道：
    2023-10-06 下午5:02

    how to get levitra without a prescription order vardenafil 10mg online cheap tizanidine price

  60. Xrklco说道：
    2023-10-05 上午3:13

    generic clomiphene 50mg order azathioprine 25mg pill azathioprine pills

  61. Neapio说道：
    2023-10-03 下午12:35

    free casino generic augmentin buy levothyroxine no prescription

  62. Rcqwzf说道：
    2023-10-02 上午12:31

    amantadine 100 mg price atenolol 50mg without prescription dapsone tablet

  63. Lndjpg说道：
    2023-10-01 下午7:34

    online black jack stromectol 3mg tablet ivermectin cream

  64. Nmvkat说道：
    2023-09-30 上午4:18

    play roulette brand ventolin 4mg order ventolin 2mg for sale

  65. Whbcmw说道：
    2023-09-28 下午11:36

    buy pantoprazole 20mg generic buy phenazopyridine 200mg online cheap pyridium 200 mg over the counter

  66. Diagwv说道：
    2023-09-28 下午12:00

    play great poker online online casinos for real money buy furosemide pill diuretic

  67. Zlcpkg说道：
    2023-09-26 下午12:14

    azipro 500mg pill omnacortil 20mg without prescription gabapentin 100mg for sale

  68. Plaxxm说道：
    2023-09-25 下午6:20

    order generic atorvastatin 40mg lipitor 20mg oral purchase amlodipine online

  69. Gkqyzx说道：
    2023-09-24 上午5:22

    accutane 40mg us order absorica sale azithromycin 500mg uk

  70. Weezwo说道：
    2023-09-22 上午6:35

    order cefdinir 300mg generic buy cefdinir 300mg generic buy prevacid paypal

  71. Zyyebq说道：
    2023-09-21 下午11:15

    order modafinil online purchase modafinil prednisone 20mg uk

  72. Qjzyhr说道：
    2023-09-18 下午2:12

    buy cialis 40mg online cheap buy viagra 50mg generic order viagra generic

  73. Orosct说道：
    2023-09-18 上午11:23

    buy cenforce online cheap chloroquine 250mg drug cost chloroquine

  74. Yhsnza说道：
    2023-09-16 上午11:21

    buy telmisartan without prescription molnunat for sale online buy molnunat 200mg pills

  75. Xplkts说道：
    2023-09-15 上午2:39

    premarin 0.625mg for sale premarin 600 mg canada cost sildenafil 50mg

  76. Veyeal说道：
    2023-09-15 上午2:38

    order prilosec 10mg prilosec 10mg uk metoprolol 50mg uk

  77. Rwlnhx说道：
    2023-09-13 上午8:17

    order xalatan eye drop generic exelon order rivastigmine 6mg

  78. Siwzzf说道：
    2023-09-12 下午11:19

    betahistine 16mg brand generic xalatan probenecid price

  79. Uqwpnd说道：
    2023-09-10 上午1:15

    pill vasotec 5mg purchase casodex duphalac brand

  80. Kvtabs说道：
    2023-09-09 上午7:09

    mestinon 60 mg oral buy maxalt 10mg online maxalt for sale online

  81. Vjxbjz说道：
    2023-09-07 上午1:08

    purchase ferrous for sale risedronate canada order betapace

  82. Puqgjj说道：
    2023-09-04 下午9:06

    buy monograph 600 mg without prescription buy monograph 600 mg buy pletal without prescription

  83. Nzgcsr说道：
    2023-09-01 上午2:15

    purchase florinef without prescription cost aciphex 20mg how to get loperamide without a prescription

  84. Tdzebr说道：
    2023-08-31 下午4:50

    dydrogesterone 10 mg sale januvia 100 mg pills jardiance 10mg usa

  85. Rauhrn说道：
    2023-08-29 上午2:27

    buy melatonin cheap capsules danazol 100 mg danocrine 100mg brand

  86. Wflvvp说道：
    2023-08-27 下午5:21

    order dipyridamole generic buy felodipine paypal buy pravachol 20mg

  87. Payzxk说道：
    2023-08-26 上午11:17

    order generic aspirin zovirax price imiquad tubes

  88. Dvwpqt说道：
    2023-08-23 上午1:35

    buy generic minoxytop tamsulosin 0.4mg cost erectile dysfunction pills over the counter

  89. Wadrkm说道：
    2023-08-23 上午1:32

    how to get precose without a prescription purchase fulvicin generic how to buy griseofulvin

  90. Zgoycu说道：
    2023-08-20 上午10:53

    buy cialis 20mg generic cialis 40mg oral sildenafil cheap

  91. Ejgbvi说道：
    2023-08-20 上午3:59

    buy ketotifen 1mg for sale buy zaditor 1mg online cheap buy imipramine generic

  92. Yhiksz说道：
    2023-08-11 上午8:15

    cheap fenofibrate 160mg buy fenofibrate 160mg without prescription fenofibrate 200mg generic

发表评论

您的电子邮箱地址不会被公开。

CAPTCHAis initialing...

公众号

微信群

人数过多只能拉人进群;

加我好友yu389741

微信小程序