MyISAM storage engine supports composite indexes that include an AUTO_INCREMENT column. : MyISAM « Engine « SQL / MySQL






  1. SQL / MySQL
  2. Engine
  3. MyISAM

MyISAM storage engine supports composite indexes that include an AUTO_INCREMENT column.

    
mysql>
mysql> CREATE TABLE multisequence
    -> (
    ->     name     CHAR(10) NOT NULL,
    ->     name_id  INT UNSIGNED NOT NULL AUTO_INCREMENT,
    ->     PRIMARY KEY (name, name_id)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table multisequence;
Query OK, 0 rows affected (0.00 sec)

mysql>








Related examples in the same category

1.Change the Type of the Table (MyISAM, InnoDB)
2.Secure backup of a MyISAM database: --lock-all-tables:
3.Change it to the more efficient MyISAM type.
4.ENGINE = {BDB | MEMORY | ISAM | INNODB | MERGE | MYISAM}
5.MYISAM engine