Differences between create table as And like in MySQL

There are two ways for MySQL to copy the same table structure: Create Table as and create table like. What is the difference?

Create Table T2 as select * from T1 where 1 = 2; or limit 0;

The T2 table (new table) created by as lacks the index information of table T1 (source table). Only the table structure is the same and there is no index.

Create Table T2 like T1;

The new table created by like contains the complete table structure and index information of the source table.

Usage:

As is used to create the same table structure and copy the source table data

Like is used to create the complete table structure and all indexes.

Oracle supports as, and only the table structure has no indexes. Oracle does not support like.