bk commit - mysqldoc@docsrva tree (jon:1.2749)

[jon]

Below is the list of changes that have just been committed into a local
mysqldoc repository of jon. When jon 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.2749 05/06/04 12:16:18 jon@stripped +1 -0
  AUTO_INCREMENT works only with integer columns.
  1.0 is not an integer.

  Docs/manual.texi
    1.2987 05/06/04 12:16:13 jon@stripped +4 -2
    AUTO_INCREMENT works only with integer columns.
    1.0 is not an integer.

# 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:	jon
# Host:	gigan.site
# Root:	/home/jon/bk/mysqldoc

--- 1.2986/Docs/manual.texi	2005-06-04 10:03:08 +10:00
+++ 1.2987/Docs/manual.texi	2005-06-04 12:16:13 +10:00
@@ -59258,7 +59258,9 @@
 @code{AUTO_INCREMENT} column, the column is set to the next sequence value.
 Typically this is @code{@var{value}+1}, where
 @var{value} is the largest value for the column currently in the table.
-@code{AUTO_INCREMENT} sequences begin with @code{1}.
+@code{AUTO_INCREMENT} sequences begin with @code{1}. Such a column must be
+defined as one of the integer types as described in @ref{Numeric type overview}.
+(The value 1.0 is @strong{not} an integer.)
 @xref{mysql_insert_id, , @code{mysql_insert_id()}}.
 
 As of MySQL 4.1.1, specifying the @code{NO_AUTO_VALUE_ON_ZERO} flag for the
@@ -88795,7 +88797,7 @@
 If the statement is an @code{UPDATE}, @code{DELETE}, or @code{INSERT},
 the total number of
 changed, deleted, or inserted rows can be found by calling
-@code{mysql_stmt_affected_rows()}. If this is a statement such as 
+@code{mysql_stmt_affected_rows()}. If this is a statement such as
 @code{SELECT} that generates a result set, you
 must call @code{mysql_stmt_fetch()} to fetch the data prior to calling any
 other functions that result in query processing. For more information on