Skip navigation links
8.1.3 Date and Time Values »
Section Navigation      [Toggle]

8.1.2. Numbers

Integers are represented as a sequence of digits. Floats use “.” as a decimal separator. Either type of number may be preceded by “-” or “+” to indicate a negative or positive value, respectively

Examples of valid integers: 

1221
0
-32

Examples of valid floating-point numbers: 

294.42
-32032.6809e+10
148.00

An integer may be used in a floating-point context; it is interpreted as the equivalent floating-point number.


User Comments

Posted by Tõnu Samuel on February 9 2004 4:30am[Delete] [Edit]

Not all ways to enter numberic data listed here. For example while first one is documented as example:

mysql> select 10e+10;

+--------------+
| 10e+10       |
+--------------+
| 100000000000 |
+--------------+
1 row in set (0.00 sec)

This one is not documented but still works:

mysql> select 10e10;
+--------------+
| 10e10        |
+--------------+
| 100000000000 |
+--------------+
1 row in set (0.00 sec)

mysql>

Such things are sometime extremely important to know for security!

Posted by John Hallyburton on May 7 2007 7:56pm[Delete] [Edit]

Through trial-and-error I have discovered the minimum and maximum positive floating point values on my system are about 1E-308 to 1E+308. I didn't see this in the documentation, but may have simply not found it yet...

Add your own comment.