Author: paul
Date: 2007-11-12 15:53:01 +0100 (Mon, 12 Nov 2007)
New Revision: 8658
Log:
r26904@frost: paul | 2007-11-12 08:50:45 -0600
Add warning that ALTER TABLE CHANGE/MODIFY might cause data alteration.
Use strict mode to prevent that from occurring.
Modified:
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
trunk/refman-6.0/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32620
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26886
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32620
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26904
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2007-11-12 11:32:05 UTC (rev 8657)
+++ trunk/refman-4.1/sql-syntax.xml 2007-11-12 14:53:01 UTC (rev 8658)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 706 bytes
@@ -431,6 +431,14 @@
or <literal>MODIFY</literal>, MySQL tries to convert
existing column values to the new type as well as possible.
</para>
+
+ <warning>
+ <para>
+ This conversion may result in alteration of data. For
+ example, if you shorten a string column, values may be
+ truncated.
+ </para>
+ </warning>
</listitem>
<listitem>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-11-12 11:32:05 UTC (rev 8657)
+++ trunk/refman-5.0/sql-syntax.xml 2007-11-12 14:53:01 UTC (rev 8658)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 963 bytes
@@ -482,6 +482,17 @@
or <literal>MODIFY</literal>, MySQL tries to convert
existing column values to the new type as well as possible.
</para>
+
+ <warning>
+ <para>
+ This conversion may result in alteration of data. For
+ example, if you shorten a string column, values may be
+ truncated. To prevent the operation from succeeding if
+ conversions to the new data type would result in loss of
+ data, enable strict SQL mode before using <literal>ALTER
+ TABLE</literal> (see <xref linkend="server-sql-mode"/>).
+ </para>
+ </warning>
</listitem>
<listitem>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-11-12 11:32:05 UTC (rev 8657)
+++ trunk/refman-5.1/sql-syntax.xml 2007-11-12 14:53:01 UTC (rev 8658)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 963 bytes
@@ -993,6 +993,17 @@
or <literal>MODIFY</literal>, MySQL tries to convert
existing column values to the new type as well as possible.
</para>
+
+ <warning>
+ <para>
+ This conversion may result in alteration of data. For
+ example, if you shorten a string column, values may be
+ truncated. To prevent the operation from succeeding if
+ conversions to the new data type would result in loss of
+ data, enable strict SQL mode before using <literal>ALTER
+ TABLE</literal> (see <xref linkend="server-sql-mode"/>).
+ </para>
+ </warning>
</listitem>
<listitem>
Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml 2007-11-12 11:32:05 UTC (rev 8657)
+++ trunk/refman-6.0/sql-syntax.xml 2007-11-12 14:53:01 UTC (rev 8658)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 963 bytes
@@ -975,6 +975,17 @@
or <literal>MODIFY</literal>, MySQL tries to convert
existing column values to the new type as well as possible.
</para>
+
+ <warning>
+ <para>
+ This conversion may result in alteration of data. For
+ example, if you shorten a string column, values may be
+ truncated. To prevent the operation from succeeding if
+ conversions to the new data type would result in loss of
+ data, enable strict SQL mode before using <literal>ALTER
+ TABLE</literal> (see <xref linkend="server-sql-mode"/>).
+ </para>
+ </warning>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8658 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 12 Nov |
