Support create table as/like query

[sundy-li]

Summary

mysql> create table test_b like test_a ;
ERROR 1105 (HY000): Code: 1002, displayText = sql parser error: Expected end of statement, found: like.
mysql>  create table (number UInt64) as select number from numbers(100);
ERROR 1105 (HY000): Code: 1002, displayText = sql parser error: Expected identifier, found: (.

Refer: https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html

[junli1026]

/assignme

[sundy-li]

@junli1026 seems create table as is not finished, would u want to continue?

[junli1026]

@junli1026 seems create table as is not finished, would u want to continue?

Sure. If I understand correctly, different from "CREATE LIKE" , the query 'CREATE TABLE t1 as SELECT * FROM t2' also copy data from t2 to t1. It does more than creating table.

Will keep working on that. 👍