BIGINT
by Hugh E. Williams, Randy Yarger, George Reese, Tim King
Managing & Using MySQL, 2nd Edition
- A Note Regarding Supplemental Files
- Preface
- I. Introduction
- 1. MySQL
- 2. Installation
- 3. SQL According to MySQL
- 3.1. SQL Basics
- 3.2. Database Creation
- 3.3. Table Management
- 3.4. MySQL Data Types
- 3.5. Indexing
- 3.6. Managing Data
- 3.7. Queries
- 3.8. SQL Operators
- 3.9. Advanced Features
- 4. Database Administration
- II. MySQL Administration
- III. MySQL Programming
- 8. Database Applications
- 9. Perl
- 10. Python
- 11. PHP
- 12. C API
- 13. Java
- 14. Extending MySQL
- IV. MySQL Reference
- Index
- About the Authors
- Colophon
- Copyright
Name
BIGINT
Description
Largest integer type, supporting range of whole numbers from
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 (0 to
18,446,744,073,709,551,615 unsigned). BIGINT has
some issues when you perform arithmetic on unsigned values. MySQL
performs all arithmetic using signed BIGINT or
DOUBLE values. You should therefore avoid
performing any arithmetic operations on unsigned
BIGINT values greater than
9,223,372,036,854,775,807. If you do, you may end up with imprecise
results.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.