MySQL Bugs: #27146: create table documentation

Bug #27146	create table documentation
Submitted:	14 Mar 2007 18:02	Modified:	2 Apr 2007 19:04
Reporter:	Martin Friebe (Gold Quality Contributor) (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	*	OS:	Any (*)
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	documentation, qc

Description:
There a a couple of syntax elements missing on the "create table" documentation
http://dev.mysql.com/doc/refman/5.0/en/create-table.html

Most of them are explained in the data-type section of the documentation
http://dev.mysql.com/doc/refman/5.0/en/data-types.html

"SERIAL"
is explained on the "create table" page, but not part of the syntax overview on top. 

"SERIAL DEFAULT VALUE" and "ON UPDATE NOW()"
are completely missing on the create table page

How to repeat:
look at the doc page

Suggested fix:
-

The CREATE TABLE page doesn't give all the details. That's why it
says:

data_type represents the data type is a column definition. spatial_type
represents a spatial data type. The data type syntax shown is 
representative only. For a full description of the syntax available 
for specfiying column data types, as well as information about the
properties of each type, see Chapter 11, Data Types, and Chapter
16, Spatial Extensions.

also missing "SIGNED"

create table t (a int(11) SIGNED);

is not documented

sorry, just overlapped.

what about the partial mentioning of "SERIAL".

If it is described on the page, should it not be part of the overview on top?

Thank you for a reasonable documentation request.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

I decided that SERIAL doesn't really belong in the CREATE TABLE
section. Instead, I moved it to the description of BIGINT in the
data types chapter, because it is an alias for BIGINT plus a set
of attributes.

For SERIAL, I've mentioned in the numeric data types overview
that the types that allow UNSIGNED also allow SIGNED, and
that it has no effect because those types are signed by
default anyway.