MySQL Sqrt()函数

MySQL Sqrt()函数

MySQL的SQRT()函数是用来找出任何数的平方根。

使用SELECT语句来查找出任何数的平方根如下:

mysql>  select SQRT(16);
+----------+
| SQRT(16) |
+----------+
| 4.000000 |
+----------+
1 row in set (0.00 sec)

在这里所看到的浮点值,是MySQL的内部操作平方根以浮点数据类型返回。

也可以使用Sqrt()函数找出各种记录平方根。要理解更详细Sqrt()函数,考虑anemployee_tbl表,其具有以下记录:

mysql> SELECT * FROM employee_tbl;
+------+------+------------+--------------------+
| id   | name | work_date  | daily_typing_pages |
+------+------+------------+--------------------+
|    1 | John | 2007-01-24 |                250 |
|    2 | Ram  | 2007-05-27 |                220 |
|    3 | Jack | 2007-05-06 |                170 |
|    3 | Jack | 2007-04-06 |                100 |
|    4 | Jill | 2007-04-06 |                220 |
|    5 | Zara | 2007-06-06 |                300 |
|    5 | Zara | 2007-02-06 |                350 |
+------+------+------------+--------------------+
7 rows in set (0.00 sec)

假设在上表基础上,要计算所有dialy_typing_pages列的值的平方根,那么可以使用下面的命令:

mysql> SELECT name, SQRT(daily_typing_pages)
    -> FROM employee_tbl;
+------+--------------------------+
| name | SQRT(daily_typing_pages) |
+------+--------------------------+
| John |                15.811388 |
| Ram  |                14.832397 |
| Jack |                13.038405 |
| Jack |                10.000000 |
| Jill |                14.832397 |
| Zara |                17.320508 |
| Zara |                18.708287 |
+------+--------------------------+
7 rows in set (0.00 sec)

92 Responses

  1. Iayhij说道:

    amoxiclav cheap levothyroxine buy online clomiphene uk

  2. Wyyjgo说道:

    escitalopram cheap order fluoxetine 20mg sale oral naltrexone

  3. Lxuilr说道:

    generic furosemide 40mg furosemide for sale buy ventolin 4mg inhaler

  4. Qaimho说道:

    order strattera generic zoloft without prescription order sertraline 100mg pills

  5. Lnmsll说道:

    actigall over the counter buy bupropion medication cetirizine 10mg over the counter

  6. Pmsrlw说道:

    order zithromax 500mg online purchase prednisolone generic buy neurontin 800mg online

  7. Ennfrs说道:

    prescription medication against stomach acid how to reduce flatulence uk pills to reduce flatulence

  8. Mrhzmw说道:

    deltasone 20mg generic order amoxil 500mg sale amoxicillin order online

  9. Fogoga说道:

    birth control patch near me fda approved premature ejectculation remedy best semen volume enhancers

  10. Wlsraq说道:

    phenergan for sale promethazine over the counter ivermectin pill cost

  11. Omwjca说道:

    best for ulcers pain and wounds fast uti treatment online scam over counter cystitis treatment uk

  12. Diiwmw说道:

    duloxetine 40mg ca modafinil order online buy modafinil 100mg generic

  13. Vjxdaq说道:

    over the counter antifungal creams fungus clear solution products common blood pressure meds list

  14. Bdtwfe说道:

    ordering valtrex overnight delivery buy asthma inhalers online canada names of drugs for diabetes

  15. Khkbuf说道:

    cyproheptadine 4 mg usa nizoral 200mg us buy ketoconazole pill

  16. Ljisxj说道:

    nicotine replacement therapy side effects drugs used for arthritis pain oapiods drugs list

  17. Pulkjg说道:

    order provera 5mg online cheap hydrochlorothiazide 25mg pills buy hydrochlorothiazide 25mg generic

  18. Paoanu说道:

    prescription for sleep aids fastest weight loss pills buy prescription weight loss medication online

  19. Cqxxtu说道:

    buy letrozole medication purchase letrozole without prescription order abilify 20mg for sale

  20. Putkji说道:

    buy alfuzosin 10mg pills anti acid medication prescription vomiting after taking medicine liability

  21. Mtwydo说道:

    buy minomycin online cheap hytrin 1mg ca buy ropinirole 1mg pill

  22. Exgtyr说道:

    treatment for acne in adults order oxcarbazepine 600mg generic purchase oxcarbazepine sale

  23. Eflmag说道:

    brand clonidine buy spiriva generic spiriva order

  24. Zeiltp说道:

    rocaltrol 0.25mg usa buy labetalol 100mg fenofibrate uk

  25. Lmmqxb说道:

    buy generic trimox over the counter buy trimox generic biaxin tablet

  26. Kbawwz说道:

    academic writing support website to write essays online casino for real money

  27. Wrdqbm说道:

    write paper online write essay on my family cefixime ca

  28. Zfgutj说道:

    purchase aspirin online slot casino online casino games for real money

  29. Oqavzo说道:

    lamisil 250mg us best online gambling sites online casino real money us

  30. Njbepx说道:

    cost desyrel 100mg buy suhagra generic order clindamycin online

  31. Jmjfmv说道:

    tadalafil order online tadalafil 20mg cheap generic indocin

  32. Ejworj说道:

    order nolvadex 20mg pills budesonide buy online rhinocort price

  33. Lpkaax说道:

    tretinoin gel usa avanafil order where to buy avanafil without a prescription

  34. Fkrxfz说道:

    buy clindamycin no prescription generic ed drugs ed pills for sale

  35. Zsikgt说道:

    generic lamotrigine 200mg mebendazole 100mg uk order mebendazole online

  36. Iufbvq说道:

    metronidazole 400mg cheap buy metronidazole 400mg online keflex 125mg pill

  37. Leabir说道:

    diflucan 200mg uk ampicillin for sale online ciprofloxacin 1000mg tablet

  38. Hcyctq说道:

    purchase aurogra sale purchase estrace sale yasmin without prescription

  39. Ixvqto说道:

    buy aldactone 25mg oral spironolactone 25mg propecia over the counter

  40. Keakqw说道:

    affordable essays buy thesis paper buying an essay

  41. Zebuhq说道:

    flomax 0.2mg over the counter buy flomax 0.2mg online cheap order simvastatin 10mg sale

  42. Wdlqtg说道:

    buy motilium 10mg generic buy generic carvedilol over the counter tetracycline cost

  43. Cpkavo说道:

    buy zantac pill purchase celecoxib pill buy generic celebrex 100mg

  44. Fhjzza说道:

    buy buspirone pills for sale zetia online buy buy amiodarone without a prescription

  45. Naqgki说道:

    buy imitrex online cheap order sumatriptan 50mg pill avodart 0.5mg pill

  46. Ucmbfm说道:

    buy generic allopurinol purchase clobetasol buy rosuvastatin 20mg online cheap

  47. Xsllbd说道:

    buy esomeprazole 20mg generic topiramate 100mg canada buy topiramate no prescription

  48. Kyuilj说道:

    how to buy astelin purchase zovirax how to buy irbesartan

  49. Sjczad说道:

    famotidine for sale online cozaar 25mg cost order tacrolimus 5mg online cheap

  50. Jprqly说道:

    buy coumadin no prescription medex for sale online buy reglan 20mg sale

  51. Evjhhc说道:

    buy generic pamelor nortriptyline 25mg canada order panadol 500 mg

  52. Gwzzdf说道:

    buy inderal generic purchase inderal for sale clopidogrel price

  53. Jjnrqt说道:

    order alendronate 70mg online cheap macrodantin 100 mg price furadantin medication

  54. Lgqdmy说道:

    buy generic glimepiride for sale buy arcoxia 60mg generic etoricoxib 120mg pill

  55. Lpajiy说道:

    buy baclofen medication buy generic lioresal online toradol 10mg pill

  56. Yqafhn说道:

    purchase lioresal for sale toradol cheap toradol oral

  57. Lysgju说道:

    buy cheap phenytoin flexeril order online oxybutynin over the counter

  58. Qerjjk说道:

    buy coversum generic allegra for sale order allegra 180mg online

  59. Cmfthk说道:

    levitra 20mg cheap purchase vardenafil sale buy tizanidine pill

  60. Gxsxwb说道:

    clomiphene uk imuran 50mg canada buy cheap generic imuran

  61. Xentbl说道:

    methylprednisolone 8 mg without prescription aristocort 10mg price triamcinolone medication

  62. Ajlryd说道:

    us blackjack online buy synthroid 75mcg pills order synthroid 150mcg for sale

  63. Hjblpw说道:

    order symmetrel 100 mg without prescription order symmetrel for sale buy dapsone pill

  64. Ctupne说道:

    real casino buy stromectol 3mg for sale ivermectin 0.5 lotion

  65. Rrfrss说道:

    playing poker online for money buy albuterol 2mg generic albuterol drug

  66. Nuulbv说道:

    pantoprazole 20mg cheap order pantoprazole 40mg pill purchase pyridium online cheap

  67. Xcgbso说道:

    casino online blackjack free slot games no download buy lasix 40mg

  68. Vwkcmp说道:

    buy azipro without a prescription how to buy azithromycin order gabapentin 800mg generic

  69. Togvhe说道:

    buy atorvastatin 10mg pills buy proventil 100 mcg pill amlodipine 5mg generic

  70. Xtjaps说道:

    order isotretinoin 10mg online order azithromycin 500mg generic where can i buy azithromycin

  71. Onkeac说道:

    oral provigil 200mg modafinil over the counter buy deltasone generic

  72. Uojfzd说道:

    cefdinir 300 mg pill glycomet 1000mg sale order prevacid without prescription

  73. Jktmuz说道:

    buy cenforce 50mg pill buy generic aralen 250mg buy generic chloroquine for sale

  74. Nvtkwb说道:

    cialis 10mg sale order tadalafil 20mg pill viagra uk

  75. Zaqisw说道:

    micardis 20mg pill movfor us movfor drug

  76. Rnjekg说道:

    brand premarin oral viagra order viagra for sale

  77. Bbhhje说道:

    order generic prilosec 20mg order lopressor generic metoprolol price

  78. Pdhbee说道:

    order betahistine 16 mg online buy probenecid cheap benemid us

  79. Dzvnqx说道:

    how to buy zovirax xalatan uk purchase rivastigmine generic

  80. Urxmcf说道:

    where to buy enalapril without a prescription order vasotec 10mg pills duphalac online

  81. Mfxixc说道:

    buy generic pyridostigmine feldene us rizatriptan 5mg cheap

  82. Fexlhx说道:

    ferrous 100mg usa order sotalol 40mg online cheap betapace 40 mg over the counter

  83. Qtxais说道:

    how to buy prasugrel tolterodine 2mg uk tolterodine order

  84. Tgcego说道:

    generic monograph 600 mg cilostazol 100 mg sale where can i buy cilostazol

  85. Qguvih说道:

    order florinef 100 mcg without prescription order fludrocortisone 100mcg sale how to buy loperamide

  86. Jdokwh说道:

    dydrogesterone for sale online purchase dydrogesterone online cheap jardiance 10mg tablet

  87. Jmlixl说道:

    melatonin 3mg drug buy meloset 3mg generic danocrine 100mg cheap

  88. Imfnqk说道:

    aspirin 75mg us order generic zovirax buy generic zovirax over the counter

  89. Rgjstq说道:

    order precose without prescription buy generic fulvicin buy fulvicin 250 mg without prescription

  90. Nrawqs说道:

    order generic tadalafil 20mg cheap sildenafil 100mg cheap sildenafil 100mg

  91. Vecjfc说道:

    buy ketotifen generic order ziprasidone 40mg pills buy tofranil for sale

  92. Oedast说道:

    where to buy tricor without a prescription buy fenofibrate tablets tricor 200mg for sale

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注

CAPTCHAis initialing...