Bug #1025 Documentation Typo in "CREATE TABLE" page.
Submitted: 10 Aug 2003 19:56 Modified: 10 Aug 2003 20:44
Reporter: Chs Merriam Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:current OS:n/a
Assigned to: CPU Architecture:Any

[10 Aug 2003 19:56] Chs Merriam
Description:
This documentation has a typo in the code fragment:
IN:  http://www.mysql.com/doc/en/CREATE_TABLE.html
====
As of MySQL 3.23, you can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: 

CREATE TABLE new_tbl SELECT FROM orig_tbl;
====
The fragment should read:
CREATE TABLE new_tbl SELECT * FROM orig_tbl;

How to repeat:
N/A.  However to verify:

mysql> CREATE TABLE list2 SELECT FROM lists;
ERROR 1064: You have an error in your SQL syntax near 'FROM lists' at line 1
mysql> CREATE TABLE list2 SELECT * FROM lists;
Query OK, 429 rows affected (0.01 sec)
Records: 429  Duplicates: 0  Warnings: 0

Suggested fix:
Fix the code snippet in docs
[10 Aug 2003 20:44] 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
product(s).