Author: paul
Date: 2006-05-05 16:37:59 +0200 (Fri, 05 May 2006)
New Revision: 2033
Log:
r10140@frost: paul | 2006-05-05 09:37:41 -0500
Add DECIMAL conversion note to upgrading and precision-math sections.
Modified:
trunk/
trunk/refman-5.0/installing.xml
trunk/refman-5.0/precision-math.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7268
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10138
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7268
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10140
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886
Modified: trunk/refman-5.0/installing.xml
===================================================================
--- trunk/refman-5.0/installing.xml 2006-05-05 14:35:33 UTC (rev 2032)
+++ trunk/refman-5.0/installing.xml 2006-05-05 14:37:59 UTC (rev 2033)
@@ -12090,6 +12090,18 @@
<programlisting>
ALTER TABLE <replaceable>tbl_name</replaceable> MODIFY <replaceable>col_name</replaceable> DECIMAL(4,1);
</programlisting>
+
+ <para>
+ The behavior used by the server for
+ <literal>DECIMAL</literal> columns in a table depends on the
+ version of MySQL used to create the table. If your server is
+ from MySQL 5.0.3 or higher, but you have
+ <literal>DECIMAL</literal> columns in tables that were
+ created before 5.0.3, the old behavior still applies to
+ those columns. To convert the tables to the newer
+ <literal>DECIMAL</literal> format, dump them with
+ <command>mysqldump</command> and reload them.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.0/precision-math.xml
===================================================================
--- trunk/refman-5.0/precision-math.xml 2006-05-05 14:35:33 UTC (rev 2032)
+++ trunk/refman-5.0/precision-math.xml 2006-05-05 14:37:59 UTC (rev 2033)
@@ -479,9 +479,16 @@
</itemizedlist>
- <remark role="todo">
- Add upgrade notes?
- </remark>
+ <para>
+ The behavior used by the server for <literal>DECIMAL</literal>
+ columns in a table depends on the version of MySQL used to create
+ the table. If your server is from MySQL 5.0.3 or higher, but you
+ have <literal>DECIMAL</literal> columns in tables that were
+ created before 5.0.3, the old behavior still applies to those
+ columns. To convert the tables to the newer
+ <literal>DECIMAL</literal> format, dump them with
+ <command>mysqldump</command> and reload them.
+ </para>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2033 - in trunk: . refman-5.0 | paul | 5 May |
