AnalyticDB for MySQL Data Lakehouse Edition (V3.0) allow you to execute the CREATE EXTERNAL DATABASE
statement to create an external database.
Usage notes
You cannot create external databases by using the
CREATE EXTERNAL DATABASE
statement for Data Lakehouse Edition (V3.0) clusters that run the Spark engine.Only external tables can be created in external databases. For more information about how to create an external table, see CREATE EXTERNAL TABLE.
Syntax
CREATE EXTERNAL DATABASE [IF NOT EXISTS] <db_name>
Parameters
db_name
: The name of the external database. For more information about the naming conventions for external databases, see Naming limits.
Examples
CREATE EXTERNAL DATABASE adb_demo;