DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) EXAMPLE storage engine

Info Catalog (mysql.info.gz) BDB storage engine (mysql.info.gz) Storage engines (mysql.info.gz) FEDERATED storage engine
 
 14.5 The `EXAMPLE' Storage Engine
 =================================
 
 The `EXAMPLE' storage engine was added in MySQL 4.1.3.  It is a "stub"
 engine that does nothing.  Its purpose is to serve as an example in the
 MySQL source code that illustrates how to begin writing new storage
 engines. As such, it is primarily of interest to developers.
 
 To examine the source for the `EXAMPLE' engine, look in the
 `sql/examples' directory of a source distribution for MySQL 4.1.3 or
 newer.
 
 To enable this storage engine, use the `--with-example-storage-engine'
 option to `configure' when you build MySQL.
 
 When you create an `EXAMPLE' table, the server creates a table
 definition file in the database directory. The file begins with the
 table name and has an `.frm' extension.  No other files are created.
 No data can be stored into the table or retrieved from it.
 
      mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE;
      Query OK, 0 rows affected (0.78 sec)
 
      mysql> INSERT INTO test VALUES(1),(2),(3);
      ERROR 1031 (HY000): Table storage engine for 'test' doesn't have this option
 
      mysql> SELECT * FROM test;
      Empty set (0.31 sec)
 
 The `EXAMPLE' storage engine does not support indexing.
 
Info Catalog (mysql.info.gz) BDB storage engine (mysql.info.gz) Storage engines (mysql.info.gz) FEDERATED storage engine
automatically generated byinfo2html