MySQL Numeric Functions

PHP Script

Java Script

Jquery Script

AJAX Script

JSP Script

Perl Script

Shell Script

ASP Script

Licensed Scripts

Premium Icons

HTML Tutorials	CSS Tutorials
Photoshop Tutorials	Flash Tutorials
JavaScript Tutorials	Jquery Tutorials
JSP Topics	Php Tutorials
MYSQL Tutorials	Regular Expression
Perl Tutorial	Domain & Dns
Unix Commands	C++
Vista Services	Linux Services
Web Building	Seo Tutorial
Powerpoint	VB.Net Tutorial
Rss Feed	GIMP

Clipart Pictures

Signs

Country Maps

Country Emblems

Background Images

Menu buttons

Logos

Menu Builder	Button Creator
Link Analyzer	DNS Lookup
Website Popularity	Color Chooser
Apache Ver Lookup	Page Rank Checker
Case Converter	Form Generator
Statistics	Epoch-GMT Converter
Hours Calculator	Htpasswd Generator
Favicon Generator	Backlink Checker
Image Crop Tool	Chart and Graph Tools
Multiple Drop Down Menu	Email Verification Tool
If Modified Since	Language Subtags
FBLike Count Calculator	SEO Text Browser

MySQL Tutorial

Home

Scripts

Tutorials

Images

Tools

Purchase

Snippets

Mysql Tutorial

Introduction

How to Install

Database

Datatypes

Tables

INSERT

SELECT

UPDATE

DELETE

Operators

Functions

Ask Your Doubts

Feedback

Mysql Numeric Functions

Tutorials

Mysql

Topic

What are the Numeric Functions In MySQL?

Explanation

MySQL Numeric Functions :

Numeric function consists of two main sections. They are :

Arithmetic Operations

Mathematical Functions

Now, lets first discuss about Arithmetic operations.

MySQL Arithmetic Operations :

In MySQL, we have the usual Arithmetic operations. Lets see the arithmetic operators one by one with an example.

MySQL Addition (+) :

mysql> select 5+5;
 -->  10

MySQL Subtraction (-) :

mysql> select 25-18;
 -->  7

MySQL Multiplication (*) :

mysql> select 4*4;
 -->  16

MySQL Division (/) :

mysql> select 5/3;
 -->  1.67

The above descriptions defines the types of MySQL Numeric Functions and Their Uses.
Next lets move to the Mathematical functions.

A Note

MySQL is the most popular open source Relational database Management system (RDBMS). Being a open source anyone can use and change the software for their needs. Hope you enjoy this tutorial. We welcome your Valuable feedbacks or suggestions on this MySQL tutorial. This is a copyright content.