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:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:* OS:Any (*)
Assigned to: Paul DuBois CPU Architecture:Any
Tags: documentation, qc

[14 Mar 2007 18:02] Martin Friebe
There a a couple of syntax elements missing on the "create table" documentation

Most of them are explained in the data-type section of the documentation

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

are completely missing on the create table page

How to repeat:
look at the doc page

Suggested fix:
[14 Mar 2007 18:07] Paul DuBois
The CREATE TABLE page doesn't give all the details. That's why it

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.
[14 Mar 2007 18:08] Martin Friebe
also missing "SIGNED"

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

is not documented
[14 Mar 2007 18:10] Martin Friebe
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?
[14 Mar 2007 18:34] Valeriy Kravchuk
Thank you for a reasonable documentation request.
[2 Apr 2007 19:04] Paul DuBois
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.