CREATE TRIGGER Statement You can now create a Disk Data table using a  CREATE TABLE  statement with the  TABLESPACE  and STORAGE DISK  options, similar to what is shown here: -> ADD DATAFILE ’mydata-1.dat’ -> USE LOGFILE GROUP mylg -> ENGINE=NDB; Query OK, 0 rows affected (2.98 sec) mysql>  CREATE TABLE mytable ( -> id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, -> lname VARCHAR(50) NOT NULL, -> fname VARCHAR(50) NOT NULL, -> dob DATE NOT NULL, -> joined DATE NOT NULL, -> INDEX(last_name, first_name) ->  ) -> TABLESPACE myts STORAGE DISK -> ENGINE=NDB; Query OK, 0 rows affected (1.41 sec) It is important to note that only the  dob  and  joined  columns from  mytable  are actually stored on disk, due to the fact that the  id ,  lname , and  fname  columns are all indexed. As mentioned previously, when  CREATE TABLESPACE  is used with  ENGINE [=] NDB , a tablespace and associated data file are created on each NDB Cluster data node. You can verify that the data files were created and obtain information about them by querying the  INFORMATION_SCHEMA.FILES  table, as shown here: For additional information and examples, see Section 23.5.10.1, “NDB Cluster Disk Data Objects” . This statement creates a new trigger. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. The trigger becomes associated with the table named  tbl_name , which must refer to a permanent table. You cannot associate a trigger with a TEMPORARY  table or a view. 2604 CREATE [DEFINER =  user ] TRIGGER  trigger_name trigger_time trigger_event ON  tbl_name  FOR EACH ROW [ trigger_order ] trigger_body trigger_time : { BEFORE | AFTER } trigger_event : { INSERT | UPDATE | DELETE } trigger_order : { FOLLOWS | PRECEDES }  other_trigger_name 13.1.22 CREATE TRIGGER Statement mysql>  SELECT FILE_NAME, FILE_TYPE, LOGFILE_GROUP_NAME, STATUS, EXTRA -> FROM INFORMATION_SCHEMA.FILES -> WHERE TABLESPACE_NAME = ’myts’; +--------------+------------+--------------------+--------+----------------+ | file_name | file_type | logfile_group_name | status | extra | +--------------+------------+--------------------+--------+----------------+ | mydata-1.dat | DATAFILE | mylg | NORMAL | CLUSTER_NODE=5 | | mydata-1.dat | DATAFILE | mylg | NORMAL | CLUSTER_NODE=6 | | NULL | TABLESPACE | mylg | NORMAL | NULL | +--------------+------------+--------------------+--------+----------------+ 3 rows in set (0.01 sec)