SQL Syntax: create table with key tuple

Asked May 13 '15 at 13:36

Active May 13 '15 at 13:36

Viewed 85 times

In the table creation statement

CREATE TEMPORARY TABLE `test` ( 
  `field1` int(11) NOT NULL,
  `field2` int(11) NOT NULL,
  KEY `field1` (`field1`),
  KEY `field2` (`field2`, `field1`)
);

what do the KEY definitions mean? I know what primary keys are, but I don't know what the tuple definition (especially of field2) behind the keys means.

In my setup, I'm using MySQL.

asked May 13 '15 at 13:36

Sh4pe

1,800
1
14
30

This is essentially a syntax for building indexes when you create the table. – Gordon Linoff May 13 '15 at 13:38
To cite the docs: _KEY is normally a synonym for INDEX_ – jpw May 13 '15 at 13:41

SQL Syntax: create table with key tuple

0 Answers0