MySQL数值函数
MySQL数值函数
MySQL的数字函数主要用于数字处理和/或数学计算。下表详细列出数字函数,这些函数可以在MySQL中执行。
名字 | 描述 |
---|---|
ABS() | 返回数字表达式的绝对值。 |
ACOS() | 返回数字表达式的反余弦值。如果值是不在范围-1到1,则返回NULL。 |
ASIN() | 返回数字表达式的反正弦。返回NULL,如果值不在范围-1到1 |
ATAN() | 返回数字表达式的反正切。 |
ATAN2() | 返回传递给它的两个变量的反正切。 |
BIT_AND() | 返回按位AND运算表达中的所有位。 |
BIT_COUNT() | 返回传递给它的二进制值的字符串表示。 |
BIT_OR() | 返回传递表达的所有位的位或。 |
CEIL() | 返回最小的整数值但不能比传递的数字表达式小 |
CONV() | 表达式从一个基数到另一个基数转换的数字。 |
COS() | 返回传递数字表达式的余弦值。数字表达式应该用弧度表示。 |
COT() | 返回传递数字表达式的余切。 |
DEGREES() | 返回数字表达式从弧度转换为度。 |
EXP() | 返回数值表达式的自然对数(E)为基数的幂。 |
FLOOR() | 返回最大整数值但不能大于通过表达式数值。 |
FORMAT() | 返回数字表达式舍入到小数位数。 |
GREATEST() | 返回输入表达式的最大值。 |
INTERVAL() | 需要多个表达式exp1, exp2和exp3等..如果为exp1小于exp2返回0,如果为exp1小于exp3返回1等。 |
LEAST() | 给两个或两个以上时,返回所有输入的最小值。 |
LOG() | 返回通过数字表达式的自然对数。 |
LOG10() | 返回传递表达的基数为10对数的数值。 |
MOD() | 返回表达式由另一个表达式除以剩余部分。 |
OCT() | 返回通过数字表达式的八进制值的字符串表示。如果传递值为NULL,返回NULL。 |
PI() | 返回圆周率的值 |
POW() | 返回一个表达式到另一个表达的次方值 |
POWER() | 返回一个表达式到另一个表达的次方值 |
RADIANS() | 返回传递表达从度转换为弧度值 |
ROUND() | 返回数字表达式四舍五入到整数。可用于舍入表达式为小数点数值 |
SIN() | 返回给定的数字表达的正弦值(弧度) |
SQRT() | 返回数字表达式的非负平方根 |
STD() | 返回数字表达式的标准偏差 |
STDDEV() | 返回数字表达式的标准偏差 |
TAN() | 返回以弧度表示数值表达式的正切值。 |
TRUNCATE() | 返回exp1小数位数字截断到exp2。如果exp2为0,则结果将没有小数点。 |
clavulanate brand brand clomiphene 100mg buy clomid generic
buy lasix pills diuretic buy lasix 40mg buy ventolin inhalator generic
purchase strattera pills buy atomoxetine generic how to buy zoloft
ursodiol 150mg ca bupropion us cetirizine 10mg pill
best supplements for indigestion can antacids cause constipation excessive flatulence nhs
zithromax cheap zithromax us gabapentin over the counter
does medical cover birth control estrogen pills buy online overcoming premature ejaculation naturally
order prednisone pills isotretinoin 20mg cost buy amoxicillin no prescription
bleeding ulcer diet mayo clinic emergency drug for hypertension sublingual does macrobid cover gram negative rods
phenergan generic buy phenergan generic ivermectin cream 1%
fungus clear vitality health ingredients fungal nail tablets blood pressure medications dosage chart
cymbalta 40mg generic buy glucotrol online cheap provigil 100mg us
does valtrex work after outbreak types of antiviral drug type 2 diabetes blood test results explained
buy generic periactin buy fluvoxamine 50mg generic order nizoral 200mg generic
stop smoking rx new medication homeopathic way to quit smoking cheapest pain pills online
buy medroxyprogesterone 10mg generic purchase hydrochlorothiazide online cheap buy microzide 25 mg generic
get sleep medication online ny times hairgrowth pills trump heathing lost pills
buy generic letrozole 2.5 mg cheap aripiprazole 30mg aripiprazole 20mg over the counter
generic alfuzosin 10mg my medicines make me puke best 24 hour heartburn relief
minocycline 100mg tablet ropinirole 1mg sale buy requip online cheap
prescription medication for adult acne buy oxcarbazepine generic buy oxcarbazepine medication
order catapres 0.1 mg generic buy tiotropium bromide online cheap order spiriva 9 mcg
buy calcitriol 0.25 mg generic calcitriol 0.25 mg sale buy tricor pill
buy essay paper gamble with real money online online casinos for real money
purchase amoxicillin generic anastrozole online buy biaxin pills
aspirin 75mg without prescription aspirin online buy online gambling casinos
buy a custom essay purchase suprax online cheap buy generic suprax
trazodone 50mg oral cost sildenafil 100mg clindac a over the counter
purchase axetil without prescription buy methocarbamol generic robaxin 500mg price
order lamisil pills terbinafine 250mg ca casino free spins no deposit
order nolvadex 20mg pills betahistine for sale cost rhinocort
tadalafil 20mg us buy indomethacin 75mg pill buy indocin cheap
cleocin cost erythromycin cost sildenafil 50mg over the counter
retin cream uk order avana 100mg pill stendra drug
buy flagyl 200mg pills buy cephalexin 250mg without prescription order keflex 500mg
lamictal 50mg for sale buy lamotrigine medication mebendazole price
buy fluconazole 200mg for sale ampicillin 500mg oral ciprofloxacin sale
sildenafil 50mg cost sildenafil for sale where can i buy yasmin
order aldactone 25mg order valtrex pill proscar 1mg uk
pay for assignment best website for writing essays my family essay writing
flomax where to buy buy simvastatin 20mg sale simvastatin 20mg generic
domperidone 10mg without prescription order motilium sale buy sumycin 500mg without prescription
buy zantac 150mg online cheap order celecoxib 100mg pills celebrex 100mg pill
order buspar 10mg online cheap purchase buspin without prescription purchase amiodarone for sale
order sumatriptan 50mg without prescription buy levofloxacin 250mg for sale dutasteride without prescription
allopurinol 300mg cost purchase allopurinol pills order crestor 20mg pills
nexium drug buy mirtazapine 15mg online how to get topamax without a prescription
purchase pepcid online cheap cozaar 50mg brand prograf 1mg over the counter
purchase azelastine generic buy generic avapro 150mg avapro 300mg canada
medex price buy metoclopramide without prescription purchase metoclopramide
cost orlistat 120mg mesalamine online buy diltiazem pill
order nortriptyline 25 mg pill paracetamol 500 mg oral purchase panadol generic
buy generic inderal 10mg buy clopidogrel sale clopidogrel over the counter
fosamax 35mg pill cheap fosamax macrodantin 100mg canada
amaryl 4mg usa glimepiride 1mg generic buy arcoxia generic
baclofen over the counter baclofen price order toradol 10mg pill
buy ozobax generic order toradol 10mg cost toradol
claritin tablet buy loratadine 10mg online priligy 90mg tablet
dilantin order online order phenytoin pills oral oxybutynin 2.5mg
generic levitra 10mg buy lanoxin online tizanidine 2mg for sale
purchase aceon sale order fexofenadine generic buy fexofenadine 120mg pills
serophene without prescription buy imdur 40mg online buy azathioprine 25mg pill
methylprednisolone 8 mg over counter buy adalat 10mg pill order triamcinolone 10mg generic
best online poker sites for real money online poker free buy generic synthroid for sale
poker online best real money spins ivermectin 3 mg tablet dosage
amantadine 100 mg for sale symmetrel for sale online brand dapsone 100mg
play poker online for money real money casino online usa purchase ventolin inhalator without prescription
online gambling slots games quick hits free online slots buy lasix generic
buy generic protonix order phenazopyridine 200 mg generic buy pyridium 200 mg generic
buy azipro 250mg generic azipro online buy buy gabapentin no prescription
cost isotretinoin 20mg order zithromax 500mg without prescription zithromax drug
oral atorvastatin 40mg proventil 100mcg cost buy norvasc 10mg pills
buy modafinil 200mg buy provigil prednisone 20mg pill
order omnicef 300 mg without prescription buy prevacid 30mg pill lansoprazole 15mg us
purchase cialis online cheap tadalafil 5mg without prescription viagra pills 25mg
cenforce 50mg usa buy aralen without prescription aralen 250mg sale
order micardis online cheap micardis buy online molnupiravir 200mg pill
buy premarin online viagra pills 50mg order sildenafil 50mg online
order prilosec sale buy omeprazole 20mg generic buy lopressor online cheap
buy zovirax online cheap rivastigmine canada exelon 6mg sale
buy betahistine 16 mg without prescription betahistine 16 mg price probenecid 500 mg cost
enalapril 10mg for sale buy lactulose paypal duphalac cheap
buy ferrous generic buy ascorbic acid online cheap purchase betapace
brand etodolac 600 mg buy monograph 600mg for sale pletal 100 mg brand
buy prasugrel 10mg pill order generic prasugrel 10 mg brand tolterodine 1mg
buy dydrogesterone pills buy dapagliflozin 10 mg online jardiance 10mg without prescription
buy florinef pills imodium online order pill imodium 2 mg
buy melatonin 3 mg without prescription norethindrone over the counter buy danocrine medication
order dipyridamole 100mg online cheap buy cheap generic pravastatin pravastatin 20mg over the counter
aspirin generic buy levofloxacin medication buy imiquimod paypal
where can i buy minoxidil cheap erectile dysfunction pill buy erectile dysfunction pills
precose 50mg tablet buy glyburide cheap buy generic fulvicin for sale
tadalafil 5mg pills sildenafil cheap brand viagra 50mg
generic fenofibrate tricor 160mg price tricor without prescription