May 2005
Intermediate to advanced
352 pages
14h 39m
English
Content preview from MySQL in a NutshellBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Appendix A. Datatypes
Every column in a table must be declared as one of the datatypes supported by MySQL. Datatypes can be organized into three basic groups: numeric, date and time, and string. This appendix provides a listing of datatypes along with their limitations.
Numeric Datatypes
Standard SQL numeric datatypes are
allowed: accurate numeric (i.e., BIGINT,
DECIMAL, INTEGER,
MEDIUMINT, NUMERIC,
SMALLINT, and TINYINT) and
approximate numeric datatypes (i.e., DOUBLE
PRECISION, FLOAT, and
REAL).
For all numeric datatypes, you can use the
UNSIGNED and ZEROFILL flags
depending on your needs. If UNSIGNED is omitted,
SIGNED is assumed. A numeric datatype has
different allowable ranges based on whether it's
SIGNED or UNSIGNED. The
ZEROFILL flag instructs MySQL to pad the unused
spaces to the left of a number with spaces. For example, a column
with a datatype set to INT(10) will display the
number 5 as 0000000005. If the ZEROFILL flag is
used, UNSIGNED is assumed for the column. When
subtracting values where one is UNSIGNED, the
results will become UNSIGNED.
For several of the numeric datatypes, a width for displaying may be
specified. This cannot exceed 255. The display width is a factor only
when ZEROFILL is used for the column. You may also
specify the number of digits allowed for the decimals, including the
decimal point.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.