Section 6.5.3 of the MySQL documentation has some slight mistakes:
Under the "create_definition:" section, the following line appears:
or CHECK (expr)
But this syntax doesn't appear to actually be supported yet (it produces an
error rather than being silently ignored).
Under the "type:" section, the following lines appear:
or CHAR(length) [BINARY]
or VARCHAR(length) [BINARY]
These should be:
or [NATIONAL] CHAR[(length)] [BINARY]
or NCHAR[(length)] [BINARY]
or [NATIONAL] VARCHAR(length) [BINARY]
The following lines also appear:
or FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
or DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
or NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
But they should be:
or FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
or FLOAT[(precision)] [UNSIGNED] [ZEROFILL]
or DECIMAL[(length[,decimals])] [UNSIGNED] [ZEROFILL]
or NUMERIC[(length[,decimals])] [UNSIGNED] [ZEROFILL]
Also, it may be prudent to make it more clear the full syntax for "tbl_name"
(optional database prefix, optional `quoting`...) with a section describing
the variations:
tbl_name:
[database.]name
or [`database`.]`name`
Come to think of it, "col_name" could benefit from that as well...
-JF
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
