Teachnique
      CourseRoadmaps
      Login

      HomeIntroductionFeaturesVersionsVariablesInstallationAdministrationPHP SyntaxNode.js SyntaxJava SyntaxPython SyntaxConnectionWorkbench

      Create DatabaseDrop DatabaseSelect DatabaseShow DatabaseCopy DatabaseDatabase ExportDatabase ImportDatabase Info

      Create UsersDrop UsersShow UsersChange PasswordGrant PrivilegesShow PrivilegesRevoke PrivilegesLock User AccountUnlock User Account

      Create TablesShow TablesAlter TablesRename TablesClone TablesTruncate TablesTemporary TablesRepair TablesDescribe TablesAdd/Delete ColumnsShow ColumnsRename ColumnsTable LockingDrop TablesDerived Tables

      QueriesConstraintsInsert QuerySelect QueryUpdate QueryDelete QueryReplace QueryInsert IgnoreInsert on Duplicate Key UpdateInsert Into Select

      Create ViewsUpdate ViewsDrop ViewsRename Views

      IndexesCreate IndexDrop IndexShow IndexesUnique IndexClustered IndexNon-Clustered Index

      Where ClauseLimit ClauseDistinct ClauseOrder By ClauseGroup By ClauseHaving ClauseAND OperatorOR OperatorLike OperatorIN OperatorANY OperatorEXISTS OperatorNOT OperatorNOT EQUAL OperatorIS NULL OperatorIS NOT NULL OperatorBetween OperatorUNION OperatorUNION vs UNION ALLMINUS OperatorINTERSECT OperatorINTERVAL Operator

      Using JoinsInner JoinLeft JoinRight JoinCross JoinFull JoinSelf JoinDelete JoinUpdate JoinUnion vs Join

      Unique KeyPrimary KeyForeign KeyComposite KeyAlternate Key

      TriggersCreate TriggerShow TriggerDrop TriggerBefore Insert TriggerAfter Insert TriggerBefore Update TriggerAfter Update TriggerBefore Delete TriggerAfter Delete Trigger

      Data TypesVARCHARBOOLEANENUMDECIMALINTFLOATBITTINYINTBLOBSET

      Regular ExpressionsRLIKE OperatorNOT LIKE OperatorNOT REGEXP Operatorregexp_instr() Functionregexp_like() Functionregexp_replace() Functionregexp_substr() Function

      Fulltext SearchNatural Language Fulltext SearchBoolean Fulltext SearchQuery Expansion Fulltext Searchngram Fulltext Parser

      Date and Time FunctionsArithmetic OperatorsNumeric FunctionsString FunctionsAggregate Functions

      NULL ValuesTransactionsUsing SequencesHandling DuplicatesSQL InjectionSubQueryCommentsCheck ConstraintsStorage EnginesExport Table into CSV FileImport CSV File into DatabaseUUIDCommon Table ExpressionsOn Delete CascadeUpsertHorizontal PartitioningVertical PartitioningCursorStored FunctionsSignalResignalCharacter SetCollationWildcardsAliasROLLUPToday DateLiteralsStored ProcedureExplainJSONStandard DeviationFind Duplicate RecordsDelete Duplicate RecordsSelect Random RecordsShow ProcesslistChange Column TypeReset Auto-IncrementCoalesce() Function

      Useful FunctionsStatements ReferenceQuick GuideUseful ResourcesDiscussion

      Feedback

      Submit request if you have any questions.

      Course
      Numeric Functions

      MySQL Tutorial

      This SQL tutorial is structured for beginners to guide them from the foundational concepts to advanced data manipulation and querying techniques in SQL. By the end of this tutorial, you will have developed a robust understanding of SQL, equipping you with the knowledge to efficiently manage and analyze data across various database systems. This guide sets the stage for your growth into a skilled data professional, ready to tackle complex data challenges and contribute to the field of data analysis and database management.

       Numeric Functions

      MySQL - Numeric Functions

      MySQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions that are available in the MySQL.
      Sr.No.
      Name & Description
      1
      ABS()
      Returns the absolute value of numeric expression.
      2
      ACOS()
      Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1.
      3
      ASIN()
      Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1
      4
      ATAN()
      Returns the arctangent of numeric expression.
      5
      ATAN2()
      Returns the arctangent of the two variables passed to it.
      6
      CEIL()
      Returns the smallest integer value that is not less than passed numeric expression
      7
      CEILING()
      Returns the smallest integer value that is not less than passed numeric expression
      8
      CONV()
      Converts numeric expression from one base to another.
      9
      COS()
      Returns the cosine of passed numeric expression. The numeric expression should be expressed in radians.
      10
      COT()
      Returns the cotangent of passed numeric expression.
      11
      CRC32()
      Returns the Cyclic Redundancy Check (CRC) for the given value.
      12
      DEGREES()
      Returns numeric expression converted from radians to degrees.
      13
      EXP()
      Returns the base of the natural logarithm (e) raised to the power of passed numeric expression.
      14
      FLOOR()
      Returns the largest integer value that is not greater than passed numeric expression.
      15
      FORMAT()
      Returns a numeric expression rounded to a number of decimal places.
      16
      HEX()
      returns the hexadecimal representation of the given value.
      17
      LN()
      Returns the natural logarithm of the passed numeric expression.
      18
      LOG()
      Returns the natural logarithm of the passed numeric expression.
      19
      LOG10()
      Returns the base-10 logarithm of the passed numeric expression.
      20
      LOG2()
      Returns the base-2 logarithm of the passed numeric expression.
      21
      MOD()
      Returns the remainder of one expression by diving by another expression.
      22
      PI()
      Returns the value of pi
      23
      POW()
      Returns the value of one expression raised to the power of another expression
      24
      POWER()
      Returns the value of one expression raised to the power of another expression
      25
      RADIANS()
      Returns the value of passed expression converted from degrees to radians.
      26
      RAND()
      Returns a random floating-point value with in the range 0 to 1.0.
      27
      ROUND()
      Returns numeric expression rounded to an integer. Can be used to round an expression to a number of decimal points
      28
      SIGN()
      Returns the sign of the given number.
      29
      SIN()
      Returns the sine of numeric expression given in radians.
      30
      SQRT()
      Returns the non-negative square root of numeric expression.
      31
      TAN()
      Returns the tangent of numeric expression expressed in radians.
      32
      TRUNCATE()
      Returns numeric exp1 truncated to exp2 decimal places. If exp2 is 0, then the result will have no decimal point.