ALTER TABLE Statement mysql>  SHOW CREATE TABLE t1\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE ‘t1‘ ( ‘c1‘ int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) mysql>  CREATE TABLE t2 (c1 INT) ts_1 ENGINE NDB; Query OK, 0 rows affected (1.00 sec) mysql>  ALTER TABLE t2 STORAGE DISK; ERROR 1005 (HY000): Can’t create table ’c.#sql-1750_3’ (errno: 140) mysql>  ALTER TABLE t2 TABLESPACE ts_1 STORAGE DISK; Query OK, 0 rows affected (3.42 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql>  SHOW CREATE TABLE t2\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE ‘t2‘ ( ‘c1‘ int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) mysql>  CREATE TABLE t3 (c1 INT, c2 INT) -> TABLESPACE ts_1 STORAGE DISK ENGINE NDB; Query OK, 0 rows affected (1.34 sec) mysql>  ALTER TABLE t3 MODIFY c2 INT STORAGE MEMORY; Query OK, 0 rows affected (3.14 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql>  SHOW CREATE TABLE t3\G *************************** 1. row *************************** Table: t3 Create Table: CREATE TABLE ‘t3‘ ( ‘c1‘ int(11) DEFAULT NULL, ‘c2‘ int(11) /*!50120 STORAGE MEMORY */ DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.02 sec) 2504 When you add an  AUTO_INCREMENT  column, column values are filled in with sequence numbers automatically. For  MyISAM  tables, you can set the first sequence number by executing  SET INSERT_ID= value  before  ALTER TABLE  or by using the  AUTO_INCREMENT= value  table option. Column  c1  uses disk-based storage, since this is the default for the table (determined by the table-level STORAGE DISK  clause in the  CREATE TABLE  statement). However, column  c2  uses in-memory storage, as can be seen here in the output of SHOW  CREATE TABLE : You can make an in-memory column into a disk-based column by using  STORAGE DISK  in a similar fashion. To change column  c2  from disk-based to in-memory storage, include a STORAGE MEMORY clause in the column definition used by the ALTER TABLE statement, as shown here: To change the storage type of an individual column, you can use  ALTER TABLE ... MODIFY [COLUMN] . For example, suppose you create an NDB Cluster Disk Data table with two columns, using this CREATE TABLE  statement: It is not necessary that the tablespace was referenced when the table was originally created; however, the tablespace must be referenced by the  ALTER TABLE :