CONNECT tables are only superficially similar to other tables. In this recipe, we'll create a CONNECT DIR table.
Enable the CONNECT engine as specified in the Installing the CONNECT storage engine recipe at the beginning of this chapter.
mysqlcommand-line client and to the
testdatabase with a user that has the
CREATEprivilege. If the
testdatabase is absent, create one.
CREATEstatement to create a table that lists the files in the data directory of the test database:
CREATE TABLE test_data ( path varchar(256) NOT NULL flag=1, filename varchar(256) NOT NULL flag=2, filesize double(12,0) NOT NULL flag=5 ) ENGINE=CONNECT DEFAULT ...