Bug #11315 builtin help explains "create view" allthough that's not implemented.
Submitted: 14 Jun 2005 12:47 Modified: 3 Aug 2005 17:23
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.1 OS:Any (All)
Assigned to: Magnus Blåudd CPU Architecture:Any

[14 Jun 2005 12:47] [ name withheld ]
If you use the command-line client for 4.1 and enter "help create view" you get a wonderful explanation with lots of examples.

Unfortunately, if you try any of those, you get a "syntax error", turns out views aren't implemented at all in that version, you need 5.0 for that.

It's more than a tiny bit confusing to have documentation for features that are not at all present. 

How to repeat:
start command-line client

type "help create view"

Suggested fix:
Remove the documentation for features that are not implemented, or at the very least, include a warning that this feature depends on version so-and-so.
[22 Jun 2005 11:12] Magnus Blåudd
There are currently one reference manual that documents all versions of MySQL. The manual  is used to fill the tables containing help for 4.1 and thus  information about functions not available in that version will show up. Your request to split the manual has been forwarded to the documentation team.

Views (including updatable views) are implemented in the 5.0 version of MySQL Server. Views are available in binary releases from 5.0.1 and up. Please see http://dev.mysql.com/doc/mysql/en/views.html

If you need to use views in your application you can upgrade to 5.0 by downloading from http://dev.mysql.com/downloads/mysql/5.0.html

Thanks for reporting the problem!