bk commit - mysqldoc tree (paul:1.2915)

[paul]

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.2915 05/04/27 19:11:51 paul@stripped +1 -0
  manual.texi:
    CREATE TABLE IF NOT EXISTS ... SELECT inserts
    regardless of prior table existence. (Bug #9884)

  Docs/manual.texi
    1.2764 05/04/27 19:11:08 paul@stripped +3 -0
    CREATE TABLE IF NOT EXISTS ... SELECT inserts
    regardless of prior table existence. (Bug #9884)

# 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.2763/Docs/manual.texi	2005-04-27 19:03:09 -05:00
+++ 1.2764/Docs/manual.texi	2005-04-27 19:11:08 -05:00
@@ -58581,6 +58581,9 @@
 @code{IF NOT EXISTS} so that an error does not occur if the table
 exists.  Note that there is no verification that the existing table has a
 structure identical to that indicated by the @code{CREATE TABLE} statement.
+Also, if you use @code{IF NOT EXISTS} in a @code{CREATE TABLE ... SELECT}
+statement, any records selected by the @code{SELECT} part are inserted
+regardless of whether the table already exists.
 
 MySQL represents each table by an @file{.frm} table format
 (definition) file in the database directory. The storage engine for the table