建表like catalog表

Viewed 29
demand

mysql> create table xx like catalog.dbname.xx;
ERROR 1105 (HY000): errCode = 2, detailMessage = errCode = 2, detailMessage = External catalog 'mysql' is not allowed in 'CreateTableLikeStmt'
是否可以增加建表时like catalog中表的功能

alaruak3
1 Answers

试试 create table xx as select * from catalog.dbname.xx where 1=0;

黄海军@SelectDB4173