Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.3464 05/09/02 18:23:01 paul@stripped +4 -0
Experimental list item index-tag shifting.
refman/column-types.xml
1.26 05/09/02 18:22:59 paul@stripped +454 -454
Experimental list item index-tag shifting.
refman-5.1/column-types.xml
1.19 05/09/02 18:22:59 paul@stripped +113 -113
Sync.
refman-5.0/column-types.xml
1.19 05/09/02 18:22:59 paul@stripped +113 -113
Sync.
refman-4.1/column-types.xml
1.24 05/09/02 18:22:59 paul@stripped +105 -105
Sync.
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: paul
# Host: frost.snake.net
# Root: /Volumes/frost2/MySQL/bk/mysqldoc
--- 1.18/refman-5.1/column-types.xml 2005-09-01 12:42:59 -05:00
+++ 1.19/refman-5.1/column-types.xml 2005-09-02 18:22:59 -05:00
@@ -67,25 +67,25 @@
</remark>
<listitem>
- <indexterm type="concept">
- <primary>display width</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>widths</primary>
- <secondary>display</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>display size</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>sizes</primary>
- <secondary>display</secondary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>display width</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>widths</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>display size</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>sizes</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
<literal><replaceable>M</replaceable></literal>
</para>
@@ -96,15 +96,15 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>digits</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>decimal point</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>digits</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>decimal point</primary>
+ </indexterm>
+
<literal><replaceable>D</replaceable></literal>
</para>
@@ -117,16 +117,16 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>brackets</primary>
- <secondary>square</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>square brackets</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>brackets</primary>
+ <secondary>square</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>square brackets</primary>
+ </indexterm>
+
Square brackets (‘<literal>[</literal>’ and
‘<literal>]</literal>’) indicate parts of type
specifiers that are optional.
@@ -332,16 +332,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>MEDIUMINT data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>MEDIUMINT data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>MEDIUMINT</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>MEDIUMINT</secondary>
+ </indexterm>
- <para>
<literal>MEDIUMINT[(<replaceable>M</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -391,16 +391,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>INTEGER data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>INTEGER data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>INTEGER</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>INTEGER</secondary>
+ </indexterm>
- <para>
<literal>INTEGER[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -449,11 +449,11 @@
<itemizedlist>
<listitem>
- <indexterm type="concept">
- <primary>rounding errors</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>rounding errors</primary>
+ </indexterm>
+
All arithmetic is done using signed
<literal>BIGINT</literal> or <literal>DOUBLE</literal>
values, so you shouldn't use unsigned big integers
@@ -593,16 +593,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>FLOAT data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>FLOAT data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FLOAT</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FLOAT</secondary>
+ </indexterm>
- <para>
<literal>FLOAT[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -694,25 +694,25 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DOUBLE PRECISION data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>DOUBLE PRECISION data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>REAL data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>REAL data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DOUBLE PRECISION</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DOUBLE PRECISION</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>REAL</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>REAL</secondary>
+ </indexterm>
- <para>
<literal>DOUBLE
PRECISION[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal> ,
@@ -821,34 +821,34 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DEC data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>DEC data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>NUMERIC data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>NUMERIC data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>FIXED data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>FIXED data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DEC</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DEC</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>NUMERIC</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>NUMERIC</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FIXED</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FIXED</secondary>
+ </indexterm>
- <para>
<literal>DEC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
[UNSIGNED] [ZEROFILL]</literal> ,
<literal>NUMERIC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
@@ -3788,22 +3788,22 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>default values</primary>
- <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
- </indexterm>
+ <para>
+ <indexterm type="concept">
+ <primary>default values</primary>
+ <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
+ </indexterm>
- <indexterm type="concept">
- <primary><literal>BLOB</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
+ <indexterm type="concept">
+ <primary><literal>BLOB</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
- <indexterm type="concept">
- <primary><literal>TEXT</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
+ <indexterm type="concept">
+ <primary><literal>TEXT</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
- <para>
<literal>BLOB</literal> and <literal>TEXT</literal> columns
cannot have <literal>DEFAULT</literal> values.
</para>
--- 1.23/refman-4.1/column-types.xml 2005-09-01 12:42:59 -05:00
+++ 1.24/refman-4.1/column-types.xml 2005-09-02 18:22:59 -05:00
@@ -66,25 +66,25 @@
<itemizedlist>
<listitem>
- <indexterm type="concept">
- <primary>display width</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>widths</primary>
- <secondary>display</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>display size</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>sizes</primary>
- <secondary>display</secondary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>display width</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>widths</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>display size</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>sizes</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
<literal><replaceable>M</replaceable></literal>
</para>
@@ -95,15 +95,15 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>digits</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>decimal point</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>digits</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>decimal point</primary>
+ </indexterm>
+
<literal><replaceable>D</replaceable></literal>
</para>
@@ -116,16 +116,16 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>brackets</primary>
- <secondary>square</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>square brackets</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>brackets</primary>
+ <secondary>square</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>square brackets</primary>
+ </indexterm>
+
Square brackets (‘<literal>[</literal>’ and
‘<literal>]</literal>’) indicate parts of type
specifiers that are optional.
@@ -378,16 +378,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>INTEGER data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>INTEGER data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>INTEGER</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>INTEGER</secondary>
+ </indexterm>
- <para>
<literal>INTEGER[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -436,11 +436,11 @@
<itemizedlist>
<listitem>
- <indexterm type="concept">
- <primary>rounding errors</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>rounding errors</primary>
+ </indexterm>
+
All arithmetic is done using signed
<literal>BIGINT</literal> or <literal>DOUBLE</literal>
values, so you should not use unsigned big integers
@@ -583,16 +583,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>FLOAT data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>FLOAT data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FLOAT</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FLOAT</secondary>
+ </indexterm>
- <para>
<literal>FLOAT[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -684,25 +684,25 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DOUBLE PRECISION data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>DOUBLE PRECISION data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>REAL data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>REAL data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DOUBLE PRECISION</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DOUBLE PRECISION</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>REAL</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>REAL</secondary>
+ </indexterm>
- <para>
<literal>DOUBLE
PRECISION[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal> ,
@@ -779,34 +779,34 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DEC data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>DEC data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>NUMERIC data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>NUMERIC data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>FIXED data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>FIXED data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DEC</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DEC</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>NUMERIC</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>NUMERIC</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FIXED</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FIXED</secondary>
+ </indexterm>
- <para>
<literal>DEC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
[UNSIGNED] [ZEROFILL]</literal> ,
<literal>NUMERIC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
@@ -4114,22 +4114,22 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>default values</primary>
- <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
- </indexterm>
+ <para>
+ <indexterm type="concept">
+ <primary>default values</primary>
+ <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
+ </indexterm>
- <indexterm type="concept">
- <primary><literal>BLOB</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
+ <indexterm type="concept">
+ <primary><literal>BLOB</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
- <indexterm type="concept">
- <primary><literal>TEXT</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
+ <indexterm type="concept">
+ <primary><literal>TEXT</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
- <para>
<literal>BLOB</literal> and <literal>TEXT</literal> columns
cannot have <literal>DEFAULT</literal> values.
</para>
--- 1.25/refman/column-types.xml 2005-09-01 12:42:59 -05:00
+++ 1.26/refman/column-types.xml 2005-09-02 18:22:59 -05:00
@@ -64,25 +64,25 @@
<itemizedlist>
<listitem>
- <indexterm type="concept">
- <primary>display width</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>widths</primary>
- <secondary>display</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>display size</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>sizes</primary>
- <secondary>display</secondary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>display width</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>widths</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>display size</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>sizes</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
<literal><replaceable>M</replaceable></literal>
</para>
@@ -93,15 +93,15 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>digits</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>decimal point</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>digits</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>decimal point</primary>
+ </indexterm>
+
<literal><replaceable>D</replaceable></literal>
</para>
@@ -114,16 +114,16 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>brackets</primary>
- <secondary>square</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>square brackets</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>brackets</primary>
+ <secondary>square</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>square brackets</primary>
+ </indexterm>
+
Square brackets (‘<literal>[</literal>’ and
‘<literal>]</literal>’) indicate parts of type
specifiers that are optional.
@@ -188,16 +188,16 @@
<!-- description_for_help_topic BIT -->
<listitem>
- <indexterm type="type">
- <primary>BIT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>BIT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>BIT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>BIT</secondary>
+ </indexterm>
+
<literal>BIT[(<replaceable>M</replaceable>)]</literal>
</para>
@@ -221,16 +221,16 @@
<!-- description_for_help_topic TINYINT BOOLEAN BOOL ZEROFILL UNSIGNED INT1 -->
<listitem>
- <indexterm type="type">
- <primary>TINYINT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>TINYINT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>TINYINT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>TINYINT</secondary>
+ </indexterm>
+
<literal>TINYINT[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -248,25 +248,25 @@
<!-- description_for_help_topic BOOLEAN BOOL -->
<listitem>
- <indexterm type="type">
- <primary>BOOLEAN data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>BOOL data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>BOOLEAN</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>BOOL</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>BOOLEAN data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>BOOL data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>BOOLEAN</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>BOOL</secondary>
+ </indexterm>
+
<literal>BOOL</literal> , <literal>BOOLEAN</literal>
</para>
@@ -288,16 +288,16 @@
<!-- description_for_help_topic SMALLINT INT2 -->
<listitem>
- <indexterm type="type">
- <primary>SMALLINT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>SMALLINT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>SMALLINT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>SMALLINT</secondary>
+ </indexterm>
+
<literal>SMALLINT[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -315,16 +315,16 @@
<!-- description_for_help_topic MEDIUMINT INT3 MIDDLEINT -->
<listitem>
- <indexterm type="type">
- <primary>MEDIUMINT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>MEDIUMINT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>MEDIUMINT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>MEDIUMINT</secondary>
+ </indexterm>
+
<literal>MEDIUMINT[(<replaceable>M</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -342,16 +342,16 @@
<!-- description_for_help_topic INT INT4 UNSIGNED ZEROFILL INTEGER -->
<listitem>
- <indexterm type="type">
- <primary>INT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>INT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>INT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>INT</secondary>
+ </indexterm>
+
<literal>INT[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -365,16 +365,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>INTEGER data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>INTEGER</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>INTEGER data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>INTEGER</secondary>
+ </indexterm>
+
<literal>INTEGER[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -389,16 +389,16 @@
<!-- description_for_help_topic BIGINT UNSIGNED ZEROFILL INT8 -->
<listitem>
- <indexterm type="type">
- <primary>BIGINT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>BIGINT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>BIGINT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>BIGINT</secondary>
+ </indexterm>
+
<literal>BIGINT[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -419,11 +419,11 @@
<itemizedlist>
<listitem>
- <indexterm type="concept">
- <primary>rounding errors</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>rounding errors</primary>
+ </indexterm>
+
All arithmetic is done using signed
<literal>BIGINT</literal> or <literal>DOUBLE</literal>
values, so you shouldn't use unsigned big integers
@@ -502,20 +502,20 @@
<!-- description_for_help_topic FLOAT UNSIGNED ZEROFILL FLOAT4 -->
<listitem>
- <indexterm type="concept">
- <primary>floating-point number</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>FLOAT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FLOAT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>floating-point number</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>FLOAT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FLOAT</secondary>
+ </indexterm>
+
<literal>FLOAT(<replaceable>p</replaceable>) [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -562,16 +562,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>FLOAT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FLOAT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>FLOAT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FLOAT</secondary>
+ </indexterm>
+
<literal>FLOAT[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -606,25 +606,25 @@
<!-- description_for_help_topic DOUBLE FLOAT8 UNSIGNED ZEROFILL PRECISION REAL -->
<listitem>
- <indexterm type="type">
- <primary>DOUBLE data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>FLOAT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DOUBLE</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FLOAT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>DOUBLE data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>FLOAT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DOUBLE</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FLOAT</secondary>
+ </indexterm>
+
<literal>DOUBLE[(<replaceable>M</replaceable>,<replaceable>B</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -658,25 +658,25 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DOUBLE PRECISION data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>REAL data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DOUBLE PRECISION</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>REAL</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>DOUBLE PRECISION data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>REAL data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DOUBLE PRECISION</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>REAL</secondary>
+ </indexterm>
+
<literal>DOUBLE
PRECISION[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal> ,
@@ -699,16 +699,16 @@
<!-- description_for_help_topic DECIMAL ZEROFILL UNSIGNED NUMERIC DEC FIXED -->
<listitem>
- <indexterm type="type">
- <primary>DECIMAL data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DECIMAL</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>DECIMAL data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DECIMAL</secondary>
+ </indexterm>
+
<literal>DECIMAL[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -792,34 +792,34 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DEC data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>NUMERIC data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>FIXED data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DEC</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>NUMERIC</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FIXED</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>DEC data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>NUMERIC data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>FIXED data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DEC</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>NUMERIC</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FIXED</secondary>
+ </indexterm>
+
<literal>DEC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
[UNSIGNED] [ZEROFILL]</literal> ,
<literal>NUMERIC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
@@ -857,16 +857,16 @@
<!-- description_for_help_topic DATE DATE -->
<listitem>
- <indexterm type="type">
- <primary>DATE data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DATE</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>DATE data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DATE</secondary>
+ </indexterm>
+
<literal>DATE</literal>
</para>
@@ -886,16 +886,16 @@
<!-- description_for_help_topic DATETIME -->
<listitem>
- <indexterm type="type">
- <primary>DATETIME data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DATETIME</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>DATETIME data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DATETIME</secondary>
+ </indexterm>
+
<literal>DATETIME</literal>
</para>
@@ -915,16 +915,16 @@
<!-- description_for_help_topic TIMESTAMP TIMESTAMP -->
<listitem>
- <indexterm type="type">
- <primary>TIMESTAMP data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>TIMESTAMP</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>TIMESTAMP data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>TIMESTAMP</secondary>
+ </indexterm>
+
<literal>TIMESTAMP[(<replaceable>M</replaceable>)]</literal>
</para>
@@ -999,16 +999,16 @@
<!-- description_for_help_topic TIME TIME -->
<listitem>
- <indexterm type="type">
- <primary>TIME data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>TIME</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>TIME data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>TIME</secondary>
+ </indexterm>
+
<literal>TIME</literal>
</para>
@@ -1027,16 +1027,16 @@
<!-- description_for_help_topic YEAR type -->
<listitem>
- <indexterm type="type">
- <primary>YEAR data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>YEAR</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>YEAR data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>YEAR</secondary>
+ </indexterm>
+
<literal>YEAR[(2|4)]</literal>
</para>
@@ -1163,43 +1163,43 @@
<!-- description_for_help_topic CHAR NATIONAL CHARACTER NCHAR BINARY -->
<listitem>
- <indexterm type="type">
- <primary>CHAR data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>NATIONAL CHAR data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>NCHAR data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>CHARACTER data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>CHAR</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>NATIONAL CHAR</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>NCHAR</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>CHARACTER</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>CHAR data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>NATIONAL CHAR data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>NCHAR data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>CHARACTER data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>CHAR</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>NATIONAL CHAR</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>NCHAR</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>CHARACTER</secondary>
+ </indexterm>
+
<literal>[NATIONAL] CHAR(<replaceable>M</replaceable>)
[BINARY | ASCII | UNICODE]</literal>
</para>
@@ -1296,43 +1296,43 @@
<!-- description_for_help_topic VARCHAR BINARY NATIONAL VARYING CHARACTER VARCHARACTER -->
<listitem>
- <indexterm type="type">
- <primary>VARCHAR data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>CHARACTER VARYING data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>CHAR VARYING data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>VARCHARACTER data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>VARCHAR</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>CHARACTER VARYING</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>CHAR VARYING</secondary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>VARCHARACTER</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>VARCHAR data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>CHARACTER VARYING data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>CHAR VARYING data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>VARCHARACTER data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>VARCHAR</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>CHARACTER VARYING</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>CHAR VARYING</secondary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>VARCHARACTER</secondary>
+ </indexterm>
+
<literal>[NATIONAL] VARCHAR(<replaceable>M</replaceable>)
[BINARY]</literal>
</para>
@@ -1396,16 +1396,16 @@
<!-- description_for_help_topic BINARY -->
<listitem>
- <indexterm type="type">
- <primary>BINARY data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>BINARY</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>BINARY data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>BINARY</secondary>
+ </indexterm>
+
<literal>BINARY(<replaceable>M</replaceable>)</literal>
</para>
@@ -1425,16 +1425,16 @@
<!-- description_for_help_topic VARBINARY -->
<listitem>
- <indexterm type="type">
- <primary>VARBINARY data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>VARBINARY</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>VARBINARY data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>VARBINARY</secondary>
+ </indexterm>
+
<literal>VARBINARY(<replaceable>M</replaceable>)</literal>
</para>
@@ -1454,16 +1454,16 @@
<!-- description_for_help_topic TINYBLOB -->
<listitem>
- <indexterm type="type">
- <primary>TINYBLOB data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>TINYBLOB</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>TINYBLOB data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>TINYBLOB</secondary>
+ </indexterm>
+
<literal>TINYBLOB</literal>
</para>
@@ -1478,16 +1478,16 @@
<!-- description_for_help_topic TINYTEXT -->
<listitem>
- <indexterm type="type">
- <primary>TINYTEXT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>TINYTEXT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>TINYTEXT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>TINYTEXT</secondary>
+ </indexterm>
+
<literal>TINYTEXT</literal>
</para>
@@ -1502,16 +1502,16 @@
<!-- description_for_help_topic BLOB type -->
<listitem>
- <indexterm type="type">
- <primary>BLOB data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>BLOB</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>BLOB data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>BLOB</secondary>
+ </indexterm>
+
<literal>BLOB[(<replaceable>M</replaceable>)]</literal>
</para>
@@ -1534,16 +1534,16 @@
<!-- description_for_help_topic TEXT type -->
<listitem>
- <indexterm type="type">
- <primary>TEXT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>TEXT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>TEXT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>TEXT</secondary>
+ </indexterm>
+
<literal>TEXT[(<replaceable>M</replaceable>)]</literal>
</para>
@@ -1567,16 +1567,16 @@
<!-- description_for_help_topic MEDIUMBLOB -->
<listitem>
- <indexterm type="type">
- <primary>MEDIUMBLOB data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>MEDIUMBLOB</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>MEDIUMBLOB data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>MEDIUMBLOB</secondary>
+ </indexterm>
+
<literal>MEDIUMBLOB</literal>
</para>
@@ -1591,16 +1591,16 @@
<!-- description_for_help_topic MEDIUMTEXT -->
<listitem>
- <indexterm type="type">
- <primary>MEDIUMTEXT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>MEDIUMTEXT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>MEDIUMTEXT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>MEDIUMTEXT</secondary>
+ </indexterm>
+
<literal>MEDIUMTEXT</literal>
</para>
@@ -1616,16 +1616,16 @@
<!-- description_for_help_topic LONGBLOB LONG LONGBINARY -->
<listitem>
- <indexterm type="type">
- <primary>LONGBLOB data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>LONGBLOB</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>LONGBLOB data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>LONGBLOB</secondary>
+ </indexterm>
+
<literal>LONGBLOB</literal>
</para>
@@ -1646,16 +1646,16 @@
<!-- description_for_help_topic LONGTEXT -->
<listitem>
- <indexterm type="type">
- <primary>LONGTEXT data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>LONGTEXT</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>LONGTEXT data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>LONGTEXT</secondary>
+ </indexterm>
+
<literal>LONGTEXT</literal>
</para>
@@ -1676,16 +1676,16 @@
<!-- description_for_help_topic ENUM -->
<listitem>
- <indexterm type="type">
- <primary>ENUM data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>ENUM</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>ENUM data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>ENUM</secondary>
+ </indexterm>
+
<literal>ENUM('<replaceable>value1</replaceable>','<replaceable>value2</replaceable>',...)</literal>
</para>
@@ -1707,16 +1707,16 @@
<!-- description_for_help_topic type SET -->
<listitem>
- <indexterm type="type">
- <primary>SET data type</primary>
- </indexterm>
-
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>SET</secondary>
- </indexterm>
-
<para>
+ <indexterm type="type">
+ <primary>SET data type</primary>
+ </indexterm>
+
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>SET</secondary>
+ </indexterm>
+
<literal>SET('<replaceable>value1</replaceable>','<replaceable>value2</replaceable>',...)</literal>
</para>
@@ -4149,22 +4149,22 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>default values</primary>
- <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary><literal>BLOB</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary><literal>TEXT</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>default values</primary>
+ <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary><literal>BLOB</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary><literal>TEXT</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
+
<literal>BLOB</literal> and <literal>TEXT</literal> columns
cannot have <literal>DEFAULT</literal> values.
</para>
--- 1.18/refman-5.0/column-types.xml 2005-09-01 12:42:59 -05:00
+++ 1.19/refman-5.0/column-types.xml 2005-09-02 18:22:59 -05:00
@@ -67,25 +67,25 @@
</remark>
<listitem>
- <indexterm type="concept">
- <primary>display width</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>widths</primary>
- <secondary>display</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>display size</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>sizes</primary>
- <secondary>display</secondary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>display width</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>widths</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>display size</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>sizes</primary>
+ <secondary>display</secondary>
+ </indexterm>
+
<literal><replaceable>M</replaceable></literal>
</para>
@@ -96,15 +96,15 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>digits</primary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>decimal point</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>digits</primary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>decimal point</primary>
+ </indexterm>
+
<literal><replaceable>D</replaceable></literal>
</para>
@@ -117,16 +117,16 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>brackets</primary>
- <secondary>square</secondary>
- </indexterm>
-
- <indexterm type="concept">
- <primary>square brackets</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>brackets</primary>
+ <secondary>square</secondary>
+ </indexterm>
+
+ <indexterm type="concept">
+ <primary>square brackets</primary>
+ </indexterm>
+
Square brackets (‘<literal>[</literal>’ and
‘<literal>]</literal>’) indicate parts of type
specifiers that are optional.
@@ -193,16 +193,16 @@
</remark>
<listitem>
- <indexterm type="type">
- <primary>BIT data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>BIT data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>BIT</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>BIT</secondary>
+ </indexterm>
- <para>
<literal>BIT[(<replaceable>M</replaceable>)]</literal>
</para>
@@ -391,16 +391,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>INTEGER data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>INTEGER data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>INTEGER</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>INTEGER</secondary>
+ </indexterm>
- <para>
<literal>INTEGER[(<replaceable>M</replaceable>)] [UNSIGNED]
[ZEROFILL]</literal>
</para>
@@ -449,11 +449,11 @@
<itemizedlist>
<listitem>
- <indexterm type="concept">
- <primary>rounding errors</primary>
- </indexterm>
-
<para>
+ <indexterm type="concept">
+ <primary>rounding errors</primary>
+ </indexterm>
+
All arithmetic is done using signed
<literal>BIGINT</literal> or <literal>DOUBLE</literal>
values, so you shouldn't use unsigned big integers
@@ -593,16 +593,16 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>FLOAT data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>FLOAT data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FLOAT</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FLOAT</secondary>
+ </indexterm>
- <para>
<literal>FLOAT[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal>
</para>
@@ -694,25 +694,25 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DOUBLE PRECISION data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>DOUBLE PRECISION data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>REAL data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>REAL data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DOUBLE PRECISION</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DOUBLE PRECISION</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>REAL</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>REAL</secondary>
+ </indexterm>
- <para>
<literal>DOUBLE
PRECISION[(<replaceable>M</replaceable>,<replaceable>D</replaceable>)]
[UNSIGNED] [ZEROFILL]</literal> ,
@@ -821,34 +821,34 @@
</listitem>
<listitem>
- <indexterm type="type">
- <primary>DEC data type</primary>
- </indexterm>
+ <para>
+ <indexterm type="type">
+ <primary>DEC data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>NUMERIC data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>NUMERIC data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>FIXED data type</primary>
- </indexterm>
+ <indexterm type="type">
+ <primary>FIXED data type</primary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>DEC</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>DEC</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>NUMERIC</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>NUMERIC</secondary>
+ </indexterm>
- <indexterm type="type">
- <primary>data type</primary>
- <secondary>FIXED</secondary>
- </indexterm>
+ <indexterm type="type">
+ <primary>data type</primary>
+ <secondary>FIXED</secondary>
+ </indexterm>
- <para>
<literal>DEC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
[UNSIGNED] [ZEROFILL]</literal> ,
<literal>NUMERIC[(<replaceable>M</replaceable>[,<replaceable>D</replaceable>])]
@@ -3780,22 +3780,22 @@
</listitem>
<listitem>
- <indexterm type="concept">
- <primary>default values</primary>
- <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
- </indexterm>
+ <para>
+ <indexterm type="concept">
+ <primary>default values</primary>
+ <secondary><literal>BLOB</literal> and <literal>TEXT</literal> columns</secondary>
+ </indexterm>
- <indexterm type="concept">
- <primary><literal>BLOB</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
+ <indexterm type="concept">
+ <primary><literal>BLOB</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
- <indexterm type="concept">
- <primary><literal>TEXT</literal> columns</primary>
- <secondary>default values</secondary>
- </indexterm>
+ <indexterm type="concept">
+ <primary><literal>TEXT</literal> columns</primary>
+ <secondary>default values</secondary>
+ </indexterm>
- <para>
<literal>BLOB</literal> and <literal>TEXT</literal> columns
cannot have <literal>DEFAULT</literal> values.
</para>
| Thread |
|---|
| • bk commit - mysqldoc@docsrva tree (paul:1.3464) | paul | 3 Sep |
