MariaDB [(none)]> CREATE TABLE `test`.`tdir`

    -> (

    -> DRIVE     CHAR(2) NOT NULL,

    -> PATH      VARCHAR(256) NOT NULL,

    -> FNAME     VARCHAR(256) NOT NULL,

    -> FTYPE     CHAR(4) NOT NULL,

    -> SIZE      DOUBLE(12,0) NOT NULL FLAG=5,

    -> MODIFIED  DATETIME NOT NULL

    -> )

    -> ENGINE = CONNECT

    -> TABLE_TYPE = DIR

    -> FILE_NAME = '/tmp'

    -> ;

ERROR 1046 (3D000): No database selected

MariaDB [(none)]> USE `test`;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [test]> CREATE TABLE `test`.`tdir`

    -> (

    -> DRIVE     CHAR(2) NOT NULL,

    -> PATH      VARCHAR(256) NOT NULL,

    -> FNAME     VARCHAR(256) NOT NULL,

    -> FTYPE     CHAR(4) NOT NULL,

    -> SIZE      DOUBLE(12,0) NOT NULL FLAG=5,

    -> MODIFIED  DATETIME NOT NULL

    -> )

    -> ENGINE = CONNECT

    -> TABLE_TYPE = DIR

    -> FILE_NAME = '/tmp'

    -> ;

Query OK, 0 rows affected (0.09 sec)