Oh yes, I almost forgot... The supported type aliases aren't mentioned in the pseudo-BNF, and they probably should be for the sake of people who are trying to learn MySQL after having used another DB product...
or BIT or BOOLEAN or DOUBLE PRECISION[(length,decimals)] [UNSIGNED] [ZEROFILL] -JF > -----Original Message----- > From: Jon Frisby [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 22, 2002 1:12 PM > To: mysql > Subject: Documentation correction... > > > 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 > > --------------------------------------------------------------------- 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
