From 296adfbebffbae0a45783521d7db30810ca9d8b5 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 25 Jul 2002 01:00:56 +0300 Subject: INSERT ... VALUES(DEFAULT) BitKeeper/deleted/.del-insert_set.test~35be5a761a410ac1: Delete: mysql-test/t/insert_set.test BitKeeper/deleted/.del-insert_set.result~fca5025db098c892: Delete: mysql-test/r/insert_set.result Docs/manual.texi: Changelog mysql-test/r/insert.result: Test new insert ... (DEFAULT) mysql-test/t/insert.test: Test new insert ... (DEFAULT) sql/item.cc: Indentation cleanup --- Docs/manual.texi | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) (limited to 'Docs/manual.texi') diff --git a/Docs/manual.texi b/Docs/manual.texi index 3bd9005f87d..e73058451dd 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -34456,13 +34456,13 @@ provide an interactive user interfaces to the database. @example INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] - VALUES (expression,...),(...),... + VALUES ((expression | DEFAULT),...),(...),... or INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] SELECT ... or INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name - SET col_name=expression, col_name=expression, ... + SET col_name=(expression | DEFAULT), ... @end example @@ -34492,6 +34492,11 @@ example, if you specify a column list that doesn't name all the columns in the table, unnamed columns are set to their default values. Default value assignment is described in @ref{CREATE TABLE, , @code{CREATE TABLE}}. +You can also use the keyword @code{DEFAULT} to set a column to it's +defaults value. (New in MySQL 4.0.3). This makes it easier to write +insert statements as you don't have to use a field-name list just because +you don't want to set a value for a few columns. + MySQL always has a default value for all fields. This is something that is imposed on MySQL to be able to work with both transactional and not transactional tables. @@ -50010,6 +50015,9 @@ Our TODO section contains what we plan to have in 4.0. @xref{TODO MySQL 4.0}. @node News-4.0.3, News-4.0.2, News-4.0.x, News-4.0.x @appendixsubsec Changes in release 4.0.3 @itemize @bullet +@item +Allow @code{DEFAULT} with @code{INSERT} statement. +@item The startup parameters @code{myisam_max_extra_sort_file_size} and @code{myisam_max_extra_sort_file_size} are now given in bytes, not megabytes. @item -- cgit v1.2.1