Bug #15979 Support table_options on create table tbl_name like tbl_name
Submitted: 25 Dec 2005 22:59
Reporter: Stuart Friedberg Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.16 OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[25 Dec 2005 22:59] Stuart Friedberg 
Description:
It would be nice if this were supported:
  create temporary table T
  like PermanentTable
  engine=merge;

However, table_options are not supported with the create ... like syntax.
Since create ... like doesn't copy the data or even the indexes, some
of the table_options seem quite reasonable.

How to repeat:
Consult the manual for syntax, and try it by hand with the command-line mysql utility.

Suggested fix:
Feature request