Home Sql Mysql-example SQL Decimal

Related Tutorials


 
 

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)
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



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

Related Tutorials

Discuss: SQL Decimal  

Post your Comment


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