Home Sql Mysql-example SQL Decimal
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

SQL Decimal

Advertisement
SQL Decimal is used to specify the values in decimal datatype.

SQL Decimal

     

SQL Decimal is used to specify the values in decimal datatype. The Decimal datatype can be of two types : Decimal (p) refers to floating point and Decimal fixed point (p,s). The DECIMAL data type can store decimal floating-point numbers up to a maximum of 32 significant digits and Decimal fixed point can store upto 16 significant digits.

Understand with Example

The Tutorial illustrate an example from 'SQL Decimal'. To understand and grasp the example we create a table 'emp' that has the required fieldnames and datatypes respectively.

Create table stu:

Create table emp( id int, name varchar(15), salary decimal(5));

Insert values:

The insert into is used to add the records to the table 'emp'.

insert into emp values (1,'Ajay',12000);
insert into emp values (2,'Bhanu',12000);
insert into emp values (3,'Komal',12000);
insert into emp values (4,'Rakesh',12000);

emp table

mysql> select * from emp;
+------+--------+--------+
| id   | name   | salary |
+------+--------+--------+
| 1    | Ajay   | 12000  |
| 2    | Bhanu  | 12000  |
| 3    | Komal  | 12000  |
| 4    | Rakesh | 12000  |
+------+--------+--------+
4 rows in set (0.02 sec)
Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 24, 2009

Ask Questions?    Discuss: SQL Decimal  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com