资源描述：
《mysql.bible2》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、124932-4ch09.F5/29/023:40PMPage210210PartII✦SQLEssentialsFigure9-37:TheDATE_FORMATfunctionallowscustomizingofdateandtimeoutputtofityourapplication.NumericalfunctionswithSELECTAsisthecasewithdatesandtimes,MySQLalsoincludesarichfeaturesetofnumericalfunctions.Table9-3listssomeoftho
2、sefunctions.Table9-3NumericalfunctionswiththeSELECTstatementABS(N)Returnstheabsolutevalueofanumber,N.xBIN(N)Returnsthebinaryvalueforthegivennumber,N.xFORMAT(N,D)Formatsthenumber,N,tothegivendecimalplace,D.xGREATEST(N1,N2,...)Providesthehighestorgreatestnumberinthegivenset,N1,N2,
3、andsoon.xHEX(D)Givesthehexadecimalvalueforagivendecimalnumber,D.xLEAST(N1,N2,...)ReturnsthesmallestorleastnumberinthelistN1,N2,andsoon.xMOD(N1,N2)Returnsthemodulovalueofthetwonumbers,N1andN2.xPI()ReturnsthevalueofPi.POW(N1,N2)Raisesanumber,N1tothepowerofanothernumber,N2.xROUND(N
4、,(D))Roundsanumber,N,totheoptionaldecimalplaces,D.SIGN(N)Determineswhetheravalueisnegative,positive,orzero.更多电子书教程下载请登陆http://down.zzbaike.com/ebook本站提供的电子书教程均为网上搜集，如果该教程涉及或侵害到您的版权请联系我们。124932-4ch09.F5/29/023:40PMPage211Chapter9✦SQLAccordingtoMySQL211MySQL’snumericalfunctionsals
5、oincludeaddition,subtraction,multiplication,anddivision.Additionandsubtractionfunctionscanbecalledthroughtheuseoftheplusandminussigns,multiplicationusestheasterisk,anddivisionusesthefront-slash(/).Forexample,thestatementSELECT4+4wouldrenderaresultof8.TheMODfunctionreturnsthemodu
6、loorremainderfromadivisionofnumbers.Thisfunctioncanalsobecalledwiththepercentsign(%).Beyondthefunctionslistedabove,MySQLalsoincludesfunctionsforcosine,tan-gent,arccosine,cotangent,random,andmore.Manyofthesefunctionsareusedonlyinspecializedapplications.Cross-Theadditionalnumerica
7、lfunctionsforusewithMySQLaredetailedinAppendixA.ReferenceThenumericalfunctionsarereallystraightforwardintheiruse.Mostacceptanum-berasanargument.SomeinterestingfunctionsincludetheBIN,HEX,andFORMATfunctions.TheBINandHEXfunctionsconvertanumberbetweenformatsbinaryandhexadecimalrespe
8、ctively.Theformatfunctionisusefulwhenyouhaveext
