[RESOLVED] Table problem

[frih]

Here is a table--

$movie = “CREATE TABLE movie (
movie_id int(11) NOT NULL auto_increment,
movie_name varchar(255) NOT NULL,
movie_type tinyint(2) NOT NULL default 0,
movie_year int(4) NOT NULL default 0,
movie_leadactor int(11) NOT NULL default 0,
movie_director int(11) NOT NULL default 0,
PRIMARY KEY (movie_id),
KEY movie_type (movie_type,movie_year)
)”;

I am unable to understand the purpose of last line-- "KEY movie_type(movie_type,movie_year)"

Why we have used KEY word. Is it creating primary key or so??

Need help--- i am new to php

[NogDog]

It means that a non-unique index (or "key") named "movie_type" is created on the combination of the two columns "movie_type" and "movie_year". Presumably it is intended to help optimize certain queries that depend on those two columns for the selection criteria.